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?