If you use a pivot table, you may want to first convert the time to an
hour of the day, assuming you are looking for the number of occurrences
in each hour of the day, rather than the number of occurrences of each
specific time. You can do this with the formula =HOUR(time), where
"time" refers to a cell in the time column.

If you don't want to use a pivot table, you should still add a column
to identify the thime interval (hour) within which the time falls and
then set up a matrix, as you seem to have planned to do, with the dates
on the left and the intervals across the top.

Assume your list of dates are in A2:A16 and time intervals are in
C2:C16.
Assume your matrix dates are listed downwards from E2 and your matrix
time intervals are listed across starting in F1.

Enter in F2,

=SUMPRODUCT(--($A$2:$A$16=$E2),--($C$2:$C$16=F$1))

and drag/copy across and down as far as necessary to cover all dates
and time intervals.


HTH

DOR