Conditions Not Accurate when subtracting time

[sly411]

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-a1>15 the answer is FALSE.

How do I subract two times and then check if the result is greater than a
value I specify?

 

[Mike H]

Hi,

=B1-A1>TIME(0,15,0)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Teethless mama]

=(B1-A1)*1440>15

 

[sly411]

Perfect, thanks

Hi,

=B1-A1>TIME(0,15,0)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

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-a1>15 the answer is FALSE.

How do I subract two times and then check if the result is greater than a
value I specify?