If formula and time
 

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.

If formula and time
 

AM is not a cell reference. Is that a named range?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Denise" wrote:

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.

If formula and time
 

Hi Denise

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

--
Regards

Roger Govier


"Denise" wrote in message
...
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.

If formula and time
 

try:

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

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

"Denise" wrote:

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.

If formula and time
 

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

On Mar 2, 5:36 pm, Denise wrote:
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.