|
|
|
|
Joined: Mar 2001
Posts: 7,431
Hard-core CEG'er
|
Hard-core CEG'er
Joined: Mar 2001
Posts: 7,431 |
Originally posted by SVTatGT:
put starting time in one cell, end time in another, daily total(end-start) in a thrird cell and sum up the daily totals for a weekly total. I can email you an example if you would like.
That only works if the employees don't work overnight. Otherwise Excel would be creating a negative amount of hours worked.
Edited because I didn't see the document you posted before writing my post - looks like Excel does indeed handle time nicely.
|
|
|
|
|
|
|
