Count hours dr

  • Thread starter Thread starter Dave08
  • Start date Start date
D

Dave08

I need to work out if a worker finishes work at 22:05 and starts at 07:00.
The reason for this is we need to know how many hours between 22:00 and 08:00
as this is consided rest time. I donot want to calculate any hours outside of
that.
 
Try this:
Being Start time in column A, Finish time in column B, 08:00 in C1, 22:00 in
D1
=MAX($C$1-A2,0)+MAX($D$1-A3,0)

Regards,
Stefi

„Dave08†ezt írta:
 
For some reason the formula is not bringing back the correct result. Did you
mean =MAX($C$1-A2,0)+MAX($D$1-B1,0). it should return a value of between 0 -
10 hours.
 
Back
Top