So being a total Excel novice I'm reaching out to the Empeggbbs brain trust for some help. I have what I think is a trivial problem that I'm hoping someone here can help with.
I trying to create a shift schedule for work and I want to calculate the total hours worked for the week. Here is what I have, as an example:
Crewmember Sunday Monday Tuesday Wednesday Thursday Friday Saturday Hours
FT1 12:00 20:00 12:00 20:00 12:00 20:00 12:00 20:00 12:00 20:00 40.00
FT2 12:00 20:00 12:00 20:00 12:00 20:00 12:00 20:00 12:00 20:00 40.00
That is start time and end time in 24HR format.
The formula for the weekly total is:
=INT((C4-B4+E4-D4+G4-F4+I4-H4+K4-J4+M4-L4+O4-N4)*24)
However if I have 00:00 as a shift end it's giving me a error, or more exactly a incorrect total of -100.00
Any suggestions? Apologies for the bad formatting above, not sure how to clean that up.
Previous Topic
Index
