Figure out the number of occurences in a time range.

I need a formula that will count the number of times a time (exp. 5:30am) occurs in a row of data like a1:a10. But i need it to be 5:00am through 6:00am etc. So for exp. if a1=5:13am, a2=5:47am, a3=5:01am, a4=6:01am the number of occurrences should be 3. Please Help!

Assuming that your source data within A1:A10 are real times - recognized by Excel
something like this should do it:
=SUMPRODUCT((A1:A10>= --"5:00 AM")*(A1:A10< --"6:00 AM"))
Note that I have used "<" for the upper limit: < --"6:00 AM"
so as not to overlap with possibly your next hour's count
--------
Success? Celebrate it, hit the little star at the bottom left of my response

Thank You! This really helped.

Welcome, good to hear. Thanks for taking a moment to feedback here. cheers