Hi,

You can use this formula to identify the time range:

=TEXT(A2,"hh")&"00-"&TEXT(A2+"1:00"+0,"hh")&"00"

I assume you can take it from here.

Sumproduct or pivot table would be my next options.