Count time (entries per hour)

Thanks for your help!

I tried that formula. It seems to be putting the counts that fall on the hour exactly following with the previous hour. If that doesn't make any sense...


12:11
12:21
12:24
12:33
12:44
12:55
13:00
13:00
13:10
13:23

The count for the 12:00 hour should be: 6
The count for the 13:00 hour should be: 4

That formula is showing a 12:00 total of 8 (including the two 13:00's) and 2 for 13:00.
It seems to be doing... 12:00:01 to 13:00:00
instead of 12:00:00 to 12:59:59


ideas?

Just move the = in ChemistB's suggestion, i.e. change to

=SUMPRODUCT(--($A$1:$A$50<C2)*($A$1:$A$50>=C1))

great... that works for all hours except 0:00.

The result should be only 100 but it's including all empty cells as 0:00 apparently.

Is there a "only include cells with data" in the count that we can add into that one?

You can filter out blanks

=SUMPRODUCT(--($A$1:$A$50<C2),--($A$1:$A$50>=C1),--($A$1:$A$50<>""))

that's it! You guys rock!

Thanks!