Conditions Not Accurate when subtracting time
 

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?

Conditions Not Accurate when subtracting time
 

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?

Conditions Not Accurate when subtracting time
 

=(B1-A1)*144015


"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?

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?