Justin1592
New Member
- Joined
- Jul 11, 2006
- Messages
- 6
Hi all,
I'm trying to create a timesheet that calculates hours worked for 3rd shift (overnight) employees.
I can't get it to return anything but negative values. I'm using the following formula:
=SUM((G10-E10),(D10-B10))) -- this takes into account both shift start and end time as wel as Lunch.
It works fine when using it for hours during the same 24 hour period, but not when the hours cross midnight.
Anyone have any ideas??
Thanks,
Justin
I'm trying to create a timesheet that calculates hours worked for 3rd shift (overnight) employees.
I can't get it to return anything but negative values. I'm using the following formula:
=SUM((G10-E10),(D10-B10))) -- this takes into account both shift start and end time as wel as Lunch.
It works fine when using it for hours during the same 24 hour period, but not when the hours cross midnight.
Anyone have any ideas??
Thanks,
Justin