True / False Formula
 

I need a formula that will return a true or false. I have a column that has
the total elapsed time. I want a column that will return true if the elapsed
time is <=0:90 and false if it is 0:90.

The formula I tried is
=AX2=00:90

The results return false for everything. I am thinking that the colon in
the time is messing up the formula.

Thanks for any help.

True / False Formula
 

Try
=AX2=TIMEVALUE("00:90")

"Denise" wrote in message
...
I need a formula that will return a true or false. I have a column that
has
the total elapsed time. I want a column that will return true if the
elapsed
time is <=0:90 and false if it is 0:90.

The formula I tried is
=AX2=00:90

The results return false for everything. I am thinking that the colon in
the time is messing up the formula.

Thanks for any help.