![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
![]() |
Nirik | Excel | 3 | 11-02-2011 06:43 AM |
![]() |
shabbaranks | Excel Programming | 3 | 09-14-2011 09:19 PM |
![]() |
Salim Khan | Excel | 1 | 08-30-2010 09:11 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |