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)

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.

It is an Excel formatted time.

"Dave O" wrote:

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.

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 Time13: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?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=389399