LATE or ONTIME

  • Thread starter Thread starter Rohinikumar
  • Start date Start date
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
 
With data in cell A1 and B1 do you mean...

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