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:

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.

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.

"Stefi" wrote:

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:

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.