Hi
I have a sheet that works out hours worked which all works fine till I hit exactly midnight .( see extract)
I am using this formula =(IF(F18>E18,F18-E18,24-E18+F18))-"00:30" (half an hour lunch)
I am using [h]:mm to format the totals but as you can see it does not work for the bottom 2...