Count hours dr

[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.

 

[Stefi]

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:

 

[Dave08]

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.