Working with If statements and time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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-D2>TIME(,5,),1,"")

or

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

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement help 3
HELP! I need to make an IF Statement comparing date/time fields.. 2
Time In-Time Out/No. of Units 10
dragging formulas across rows 2
If/Then Statement help 3
Schedule Worksheet 7
CountIf with And 0
IF Function 3

Back
Top