Thread: LATE or ONTIME
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default LATE or ONTIME
With data in cell A1 and B1 do you mean...

In cell C1
=IF(B1A1,"Late","Ontime")

--
Jacob


"Rohinikumar" wrote:

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

Reply With QuoteReply With Quote