View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default 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.