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.
|