Counting Occurences of Hours of the Day

[Guest]

I have a spreadsheet that lists customer contact times by the time of day.
Is there a formula that will count the number of customers each hour, i.e.
00, 01, 02...(24 hour time clock)

 

[Dave O]

Darren-
Is the timestamp an Excel formatted time, or is it a text string? The
answer to this question drives the way we can figure this out. If
you'll provide an example of your source data it will help out.

 

[Guest]

It is an Excel formatted time.

 

[swatsp0p]

Here is one way that uses two columns, one to list the hours of the day
(00-23) and one to COUNTIF the values in your call time column, as
such:

Assumes your Call Time data is in Column A2:A100 and using Columns C
and D to calculate the count....

Start by formatting col. C as Time>13:30 and in C2 enter 0, in C3 enter
1:00. Highlight both cells and using the drag handle, drag this down
through row 25 (to give you the hours through 23:00).

In D2, enter this formula:

=COUNTIF($A$2:$A$100,">="&C2)-COUNTIF($A$2:$A$100,">="&C3)
and copy down to row 25. (make sure to format this range as General)

Does this work for you?