Hi Howard,

Am Fri, 26 Dec 2014 18:49:12 -0800 (PST) schrieb L. Howard:

What formula can I use by itself OR in conjunction with =IF(B2$F$1,1,"") to show in either column C or D the number of minutes the B values were greater than the F1 value.

Where the above would show times of:

7:00 = 1 min
7:03 to 7:06 = 3 min
7:11 to 7:13 = 2 min

in C1 try:
=IF(B1$F$1,1,"")
in C2 try:
=IF(AND(B2$F$1,ISNUMBER(C1)),C1+1,IF(B2$F$1,1,"" ))
and copy down

For everything else you need VBA


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional