labor schedule

  • Thread starter Thread starter mtbr00x
  • Start date Start date
M

mtbr00x

does anyone know what formula I would use to figure time in excel. fo
instance if i want to write a schedule, say jon was scheduled to wor
monday from 10:00 am to 3:00 pm on monday and 10:30 to 2:00 on tuesday
how would i write a formula to calculate his hours for the week usin
the time format? thanks for any hel
 
If you wanted to check just one start to end time, you could use a formula like
(a1 is start time and b1 is end time):

=B1-A1+IF(A1>B1,1,0)
(or somewhat shorter)
=B1-A1+(A1>B1)

If you have start times in A1:A10 and end times in B1:B10, you could get the
total sum:

=SUMPRODUCT(B1:B10-A1:A10+(A1:A10>B1:B10))

Format each formula cell as time: [hh]:mm

The brackets are important so you can see totals like: 40:30)
 
Back
Top