Creating a volume chart based on HH:MM:SS data.

I have a set of data approximatly 300 rows long. The format is HH:MM:SS. Each cell relates to the time an incoming call hit our switch board.

I want to show in a line graph what the volume of incoming calls is.

Using the chart wizard produces a single point. So the obvious answer seems to be to use ranges of one hour so as to show how many calls from 00:08:00 to 00:08:59 and so on throughout the day. This is where I get stuck. Any ideas? I have attached small data sample.

You could perhaps use a Pivot Chart ?
(see attached and review notes re: coercion of data to numbers from text)

For more info on intro to PT/PT Charts see the link in my signature.

That seems to have hit the spot. Thanks

It may be a little simplistic for you guys but in the end I went with a new column:

=hour(a1) to give a single digit hour
e.g 07:19:54 becomes 7.

Then 24 countif cells =COUNTIF(B1:PB003,"1") TO =COUNTIF(B1:B3003,"24")

Then graphed the results.

Less elegant I know but hits the spot