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")
 

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

Amending meeting cancels all future meetings 0
sumif with detail 3
Conditional Formatting Times 1
Finding percentages 1
Countdown macro - display settings 2
Time formula over two days 6
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Status and % complete of predecessor task 0

Top