How to highlight greter than values

[vinayvanam]

Hi, in "A" cell time 6.00am "B" cell time is 5.50 its "ontime", if "B" value greter than "A" "Delay" Please apply formula for this

6.00	5.50
7.00	6.50
8.00	8.10
9.00	8.52
10.00	9.40
11.00	11.15
12.00	12.20
13.00	12.50
14.00	14.5
15.00	15.10
16.00	16.00
17.00	17.00
18.00	17.50

<tbody>
</tbody>

 

[Rick Rothstein]

I think this does what you want...

=IF(B1>A1,"Delay","Ontime")

 

[vinayvanam]

If "A1"= 6.00 "B1" should be =5.50 ten min is buffer, its ontime

 

[Rick Rothstein]

If "A1"= 6.00 "B1" should be =5.50 ten min is buffer, its ontime[/QUOTE
A question about your time notation.... are you saying 5.50 is how you write 50 minutes after 5 o'clock (as opposed to the standard method of writing it as 5:50)?