IF statement for time based data
If it doesn't work for you, then I guess that your data in K1 is not
actually a time, but text. If it's really a time, then if you change the
format temporarily to Number it'll show was 0.00347222222222222
--
David Biddulph
"Daren" wrote in message
...
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.
|