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


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!