Count occurances between times on certain date

[Muffle]

Hello All,

I'm trying to do a formula that will pick out occurrences between 30 minute intervals, I also want this to be filtered by date however I'm struggling to compose a formula that can do this.

So far I have this "=SUMPRODUCT((B2:B101<=C2)*(B2:B101>D2))" this will pick out the occurrences between times however won't filter them by data (Column A).

Anyone able to help me out?

 

[jim may]

What's in your Column A?
What happens if you enter (additionally, in RED)...

"=SUMPRODUCT((B2:B101<=C2)*(B2:B101>D2)​

*A2:A101​

)"​

 

[Muffle]

Thanks for your response Jim May, but it didn't work. When I've entered your formula it just brings up a random value that is definitely not related to my spreadsheet.

 

[jim may]

But what is in Column A? Text or numbers?