Barry Houdini provided the following which helped divide my data set into 15 min chunks of time and list the number of counts in each time period:
=SUMPRODUCT((FLOOR(MOD(B$1:B$4,1),"0:15")=C1)+0
where B is time of an event in hours:minutes.
This worked well on a small data set using 15...