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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula and time
AM is not a cell reference. Is that a named range?
-- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Denise" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula and time
Hi Denise
Try =IF(AM1<=TIME(0,30,0),TRUE,FALSE) or even =AM1<=TIME(0,30,0) -- Regards Roger Govier "Denise" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula and time
try:
=IF(AK1<=TIME(0,30,0),"True","False") I assume AK is the column so cell address should be AK1, AK2 etc. "Denise" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula and time
Do you mean that if you had 5:29 in the cell you would like this to be
TRUE and if it was 5:31 in the cell you would want this to be FALSE? Pete On Mar 2, 5:36 pm, Denise wrote: 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. |
Reply |
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 |