use time functions inside if loop

[saedeepu]

I have a prob with if loop and time functions.
I want to compare time in one cell with another time.

ex: cell a1- 2:30 , in b2 i want to compare if(a1>1:30,"t")

it is not coming.

 

[Jacob Skaria]

Try
=IF(A1>TIME(1,30,0),"t","f")

If this post helps click Yes

 

[David Biddulph]

=IF(A1>TIME(1,30,),"t")