If formula and time

[Guest]

I want to to use a formula to return "true" in cell AM if cell AK is <=00:30
and false if it is >00:30

I am using the formula =if(AM<=0.020833333,TRUE,FALSE)

This is returning FALSE for any time that is 00:30 or greater. I tried
putting 00:30 in the formula but it wont accept that.

Thanks for any help.

 

[Guest]

AM is not a cell reference. Is that a named range?

 

[Roger Govier]

Hi Denise

Try
=IF(AM1<=TIME(0,30,0),TRUE,FALSE)
or even
=AM1<=TIME(0,30,0)

 

[Guest]

try:

=IF(AK1<=TIME(0,30,0),"True","False")

I assume AK is the column so cell address should be AK1, AK2 etc.

 

[Pete_UK]

Do you mean that if you had 5:29 in the cell you would like this to be
TRUE and if it was 5:31 in the cell you would want this to be FALSE?

Pete