Count Question

[siouxprincess]

How do I count how many "Not Determined" between 00:00:00 and 05:00:00 ?

Column A:
A1: Not Determined
A2: No Problem Found
A3: Not Determined
A4: Operator Error
A5: Operator Error
A6: Not Determined

Column B:
B1: 00:06:00
B2: 05:35:01
B3: 50:56:45
B4: 01:00:01
B5: 20:00:00
B6: 01:26:35

 

[LxQ]

=SUMPRODUCT(--(A1:A6="Not Determined"),--(B1:B6>=0),--(B1:B6<=0.20833))

 

[LxQ]

actually, make that <0.20834 just so it would include 5:00:00 as well..