Gate loog sheet

[ajs007]

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

[Pecoflyer]

To determine time on site simply enter =I2-H2 and format as needed

If you want to keep the cells empty as long as one of the cells is blank, try

=IF(or(I2="",H2=""),"",I2-H2)

To summarize at the end of the month, a Pivot Table would to the trick

PS if anybody stays more than 24 hrs on site format as [h]:mm:ss