LATE or ONTIME

R

Rohinikumar

Hi pls check the below i want to know how to create auto formate LATE OR ONTIME

Log I Time Cab Reach TimeRemark
12:30 12:45 LATE
12:30 12:30 ONTIME
 
J

Jacob Skaria

With data in cell A1 and B1 do you mean...

In cell C1
=IF(B1>A1,"Late","Ontime")
 
Top