I am doing an employee check in sheet. I want to enter the time an employee finishes for the day, compare that time to quitting time and display the amount of overtime worked if any. =IF(cell>6:30,cell-6:30,0) is what I am trying to use. Time isn't a valid value though.

Please advise!