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