24 hour day - having trouble with 20:30pm to 01:00am
- by Tom
I'm having problems figuring hours worked, with a 24 hour day formula that accounts for swing and graveyard
this is a 4 column layout - example below (I only need to figure totals hours worked minus Lunch)
example:
in 20:30 out (lunch) 01:00 in(lunch) 01:30 end of shift 06:30
Answer should be: should be 4.5+5 = 9.5 hours worked …