Conditions Not Accurate when subtracting time
Perfect, thanks
"Mike H" wrote:
Hi,
=B1-A1TIME(0,15,0)
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"sly411" wrote:
When I subtract two times e.g.
b1 is 21:35
a1 is 20:55
the answer shows correctly i.e. 40:00 (using [m]:ss format) but when I set
the condition b1-a115 the answer is FALSE.
How do I subract two times and then check if the result is greater than a
value I specify?
|