Charting time in excel

[Thant]

Greetings,
I have a report for a call center which amongst many other data points lists Average answer delay. This report lists out in increments of 15 minutes and the data points within that 15 minutes are the average speed it took someone to answer a call it is in HH:mm:ss format. I have no idea how to get excel to chart this time to show me at what 15 minute intreval our callers are holding for the longest time.
I have attempted this before but found no way of getting excel to understand the HH:mm:ss format that the report is using
Any help here would be appreciated

			Answer	Avg	Max. Answer
Skillset Calls:					
	Offered	Answered	Delay	Ans Delay	Delay
					GRAND TOTAL
	863	826	08:57:11	00:00:39	00:10:17
					
Summary:	863	826	08:57:11	00:00:39	00:10:17
[] 3/22/2010					
08:00	0	0	00:00:00	00:00:00	00:00:00
08:15	0	0	00:00:00	00:00:00	00:00:00
08:30	1	0	00:00:00	00:00:00	00:00:00
08:45	0	0	00:00:00	00:00:00	00:00:00
09:00	9	8	00:07:03	00:00:53	00:02:51
09:15	5	5	00:01:01	00:00:12	00:00:21
09:30	10	9	00:02:57	00:00:20	00:00:35
09:45	7	7	00:01:13	00:00:10	00:00:24
10:00	5	5	00:01:04	00:00:13	00:00:27
10:15	8	8	00:01:26	00:00:11	00:00:18
10:30	6	6	00:07:41	00:01:17	00:03:28

 

[mintjulep]

Make a column chart of whatever series you are interested in with the times in column A as their X values.

Poof, histogram.

 

[SkipVought]

hi,

I have attempted this before but found no way of getting excel to understand the HH:mm:ss format that the report is using

Do you KNOW that you have REAL TIME VALUES, or just TEXT?

The way to determine this is to change the format of the time and duration values to GENERAL.

If the display values CHANGE to NUMBERS, for instance...
[tt]
9:30 10 9 0:02:57 0:00:20 0:00:35
chnages to
0.395833333 10 9 0.002048611 0.000231481 0.000405093
[/tt]
then you have real time values, in which case we need to look for another set of problems.

However, if you have TEXT values, then you must convert the TEXT to TIME VALUES.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Thant]

It would appear that I have text values. I have tried changing the fields to number and got no change in the data at all.
If I understand what you are saying I should convert those fields into a time format and try charting them that way?
Thanks

 

[SkipVought]

To CONVERT
[tt]
1. enter a1 in an empty cell.

2. copy that cell

3. select the text date range

4. Edit > Paste Special -- MULTIPLY

5. set the time format that you want.
[tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}