=IF(COUNT(B2:C2)=2,SUMPRODUCT(--(B2:B100<=--"8:00"),--(C2:C100=--"8:59")),"")


"jerry" wrote:

I have a 4 column spreadsheet. Col a = date, Col b = time in, Col c = time
out, Col d = minutes spent. I would like to count all the entries that fall
between the hrs of 8:00 AM and 8:59 AM IF there are entries in both column b
and c. If there are not entries in both col B and col C, I want to disregard
those items. Help would be appreciated.