Help with "IF" statement using time

[michaelhannaster]

14:00/23:00 14:00:37/23:11:49

a bit of a newbit in writing formulas and i can't figure out for the life of me to get what i need on this one. I have 4 rows a Log in/log out one is scheduled and one is actual. I need to figure out a formula that will flag the actual row when it exceeds 6 minutes from actual..any help would be GREATLY appreciated

[daddylonglegs]

Try a formula like this

=IF(B1-A1>"0:06","late","")