Time worked after midnight

This is a variation of my earlier post:-

http://www.excelforum.com/excel-gene...tain-time.html

I now need the hours worked after midnight - assuming the shift finishes the next day. See the attached sheet for examples and expected answers. thanks

regards

Kaps

Hi, Maybe

Please Login or Register  to view this content.

Formatted as [hh]:mm

I think your last example should have a start date of 24th March for the desired result, and you can achieve it using this formula in E3:

=(C3-B3)*(INT(C3)>INT(B3))

and copying down.

Hope this helps.

Pete

Thanks. Pete you are correct in spotting my typo.

However neither of your formulae give the correct result - when I type in 23/03/2012 20:00 and 23/03/2012 23:50 - I get 23:50 rather than zero. Any ideas what I am doing wrong ?

kind regards

Kaps

sorry - ignore last post - I was being an idiot - found the error.

Okay, please mark the thread as Solved (the FAQ shows you how). Also, you can click on the "star" icon in the bottom left corner of any post that has helped you, in order to pass on thanks directly.

Pete