I am trying to make a excel spreadsheet for entry and exit data but im a bit lacking in the excel area the things i want i am sure they can be done but i just don't know how to do them.

This is the situation i am at a gate and need to log all details for persons going in and out. What i am stuck on is excel doing a auto calculate the amount of time on site based on entry and exit time. Then at the end of the month doing a total hours report for visitors and contractors.

Any help would be great i have attached a zip file with a basic idea.



Also is there any paid programs that can do the same thing

Attached Files

LOG SHEET.xlsx (11.0 KB, 11 views)