I'm need a formula to count the number of registrations per hour for each day
of the week.

Example:
A B
Day Registration time
Sun 0530
Sun 0546
Sun 0600
Sun 0702

How many entries are for Sunday and fall between 0500 and 0600?

I've tried a countif function and a sumproduct function to no avail.

Thanks,
Dana