Forgot to add =. See below for corrected.

"Sean Timmons" wrote:

Assuming the cells are formatted as time, keep in mind that the hours of the
day are counted as 1/24th each. So, 10:00 AM is 10/24ths, or 5/8ths of 1.
Decimal version is .125. 11:00 AM is 11/24th. decimal is .4458333. So, your
formula can be:

=countif(B:B,=.125)-countif(B:B.44583333)

This assumes the start time is in column B.

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