| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time formula | New Users to Excel | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Threaded Mode
