Hello,

This is my first post here. I have actually posted this thread in another forum :-

http://www.mrexcel.com/forum/showthread.php?t=630842

but have yet to get a reply.

In cells A1 and B2 I have the start and end times of a shift. These are specified in the format dd:mm:yy hh:mm e.g 23/04/2012 16:00 and 24/04/2012 03:00. I need the number of hours worked after 20:00 hours. In this case the answer is 7 hours.

Note as this is for a hospital, there is not a fixed "ground zero" i.e a fixed point in time where rollover occurs - as there are always staff working.

Thanks

Kaps