Prev: formula patterns with a gap of two
Next: Restrict data entry in a cell
From: sly411 on 18 Mar 2010 14:58
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?
From: Mike H on 18 Mar 2010 15:03
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.


"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-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?
From: Teethless mama on 18 Mar 2010 15:26
=(B1-A1)*1440>15


"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-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?
From: sly411 on 18 Mar 2010 16:18
Perfect, thanks

"Mike H" wrote:

> 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.
>
>
> "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-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?
 | 
Pages: 1
Prev: formula patterns with a gap of two
Next: Restrict data entry in a cell