=SUMPRODUCT((F1:F122="BTsD")*(H1:H122<TIME(8,0,0)) ,J1:J122)

Where your range of data is in rows 1 to 122, adjust accordingly

Regards

Dav

PS Remember you are excluding 8:00, if you wish to have it included
select <= instead of <


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509351