C

#### candros

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.