Gate loog sheet
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
|