az willie wrote:
I have a column of times in 24 hour format. I want to have a formula that
counts the number of cells in the column that contain a time in a certain
range.

That is if the cell contains a time between 22:00 and 23:00 the cell should
be counted. I will have to do that for each hour.

I am trying to determine how many times during the night events happen in
each time period. So I want to have a formula that counts the cells that
fall within the time periods.

I have tried =COUNTIF(I47:I3846,"23:01:<24:00")but it just returns zeros
and I know there are cells with times in that range.

All help / suggestions / solutions / jokes appreciated :)



You could use a PivotTable. Put the Times in the Row and Data Items areas. In
the Row area, group by Hours.