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