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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif with detail 3
Conditional Formatting Times 1
Finding percentages 1
Time formula over two days 6
IF statement and Network days 2
.ontime 2
Excel Catagorise AM or PM 7
Value error with this formula 5

Back
Top