Working with If statements and time

[Sue]

I am trying to figure out If statements with time that is written as 19:57
(7:57 PM). In cell D2 I have the Paged Time to ER and in cell E2 I have the
Arrived Time to ER. I want Excel to place a "1" in F2 when it took more than
5 minutes to arrive in the ER. I also am wanting Excel to place a "1" in cell
G2 when it took more that 10 minutes to arrive in ER. How do I set this up???
Thanks!

[Jason Morin]

Time is nothing more than a number in Excel. In F1 you
could use:

=IF(E2-D2>TIME(,5,),1,"")

or

=IF(E2-D2>--"00:05:00",1,"")

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I am trying to figure out If statements with time that
is written as 19:57
>(7:57 PM). In cell D2 I have the Paged Time to ER and in
cell E2 I have the
>Arrived Time to ER. I want Excel to place a "1" in F2
when it took more than
>5 minutes to arrive in the ER. I also am wanting Excel
to place a "1" in cell
>G2 when it took more that 10 minutes to arrive in ER.
How do I set this up???
> Thanks!
>.
>