Note that while "6:00" is greater than "5:00" in a text comparison, "13:00"
is less than "5:00", as "1" comes before "5".

Others have given other answers.
--
David Biddulph

"candros" wrote in message
...
I'm working on a time card and have three shifts. The start and end time
are
formated to time, the cell with the formula is formated as [h]:mm, the
formula I'm using is
IF(TEXT(E16-D16,"h:mm")"5:00",H16-$G$1,TEXT(E16-D16,"h:mm"))
this works for day's and afternoon shifts but will not work for the
midnight
shift from 10:30pm to 7:00am. I'm also calculating two different way's
depending on if the shift is over 5 hours. What formula do I need to use
to
cover the midnight shift.