Hi!

Try this:

=IF(COUNT(C3:D3)=2,IF(--G3TIME(0,7,0),"No",IF(--G3<=TIME(0,7,0),"Yes")),"")

Biff

wrote in message
oups.com...
Hello all,

I am having a bit of trouble with trying to use the IF Statement in
Excel when it comes to TIME.

This is what I am trying to do:

In Cell G3, it calculates minutes elapsed by using the following:

=TEXT(D3-C3, "h:mm:ss")

In Cell H3, I am trying to make it so that if Cell G3 is more than 7
Minutes, it writes "NO", and if the same cell is Less or Equal to 7, it
writes "YES"

Here is what I have in Cell H3:

=IF('7 or Less Articles'!G37,"No",IF('7 or Less
Articles'!G3<=7,"Yes"))

To make a long story short, it's not calculating properly.

Cell D3 is 9:03
Cell D3 is 9:00

9:03 minus 9:00 is 3 minutes, therefore Cell H3 should say "YES" -
instead it's saying "NO" I've been at this for several days trying to
find a solution.

I will appreciative of any help someone can provide.