I am trying to substract time and the value is comming back only in positive

Karma

here is my formula

=SUM(TIME([Time Scheduled ]@row) - TIME([Time Finish Load/Unload]@row))

and here is my if formula

=IF(Difference1 < 0, "Late", "On Time")

and i have attached the sheet, i am trying to return the value where i can see late and on time, but my formula is returning back all the numbers in positive even the negative ones are coming back in positive, and that is showing all "on time" even though i have some that are late.

Paul Newcome

Try something along the lines of

=IF(TIME([Time Scheduled ]@row) > TIME([Time Finish Load/Unload]@row), "On Time", "Late")