Working with If statements and time
 

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!

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

=IF(E2-D2TIME(,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!
.