Possibly:

=SUMPRODUCT(--(TEXT(A2:A1000,"hh\:\0\0")="10:00"))

for times of arrivals from 10am to 10:59am. Modify range to suit.

Hope this helps!

Richard


Beginner wrote:

I need to count the number of occurences between the hours of the day. For
example:
Time arrived
#of Members
Member1 - 10:30 7:00
Formula
Member2 - 11:46 10:00
Formula inserted
Member3 - 10:49 11:00
and so forth
Member4 - 11:35

How can I write a formula to count the number of members that arrive at
10:00 -11:00?

Any or all help is appreciated!!!
Thanks