IF statement for time based data
My suggested formula returns a blank if the time in K1 is not equal to or
between the specified limits.
How is K1 generated, is there a formula in that cell? The actual value may
be slightly above 0:05, e.g. if K1 contains 0:05:01 but the cell is formatted
as h:mm. In this situation the value is above five minutes so the result is
correct.
"Daren" wrote:
Tried it, but it returns a blank. I also tried just 1 & 5 for the times
(e.g., k1=1), but that didn't help either.
"daddylonglegs" wrote:
Try this
=IF(AND(K1="0:01"+0,K1<="0:05"+0),"1-5","")
"Daren" wrote:
I'm trying to use an IF statement for time based data. The data that I'm
evaluating is in the 0:05 time format, which is the same as [h]:mm format in
custom formatting under cell formats.
Here's the scenario. The data in cell k1 is 0:05. I'm trying to evaluate
if this value is greater than or equal to 1 and at the same time less than or
equal to 5. My current logic statement is set as:
=IF(1<=k1<=5, "1-5",false). This returns false.
I've also tried =IF(0:01<=k1<=0:05,"1-5",false), but that results in an error.
Please help.
|