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

I don't know what your expected output should be.
Please look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "Times"


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