Hi DonkeyOte,

Thanks for your reply.
I think that your formula calculates the answer, but has the same problem with shifts that fall across midnight.

Perhaps I haven't defined my problem clearly enough.

Continuing with the attached example:

Upper Bound: 22:00 (10pm)
Lower Bound: 7:30 (7.30am)

I am trying to determine the number of hours worked on night shift between these times ie. 10pm-7.30am. This is to be displayed in E10.

Thanks again.