Trying to calculate average call length
pilates_jocelyn wrote:
Usually our phone system spits out a report for me, but it's broken right
now... and I have to provide this info to another department ASAP.
I'm trying to calculate the average call length for our call center agents.
My spreadsheet looks like this:
Call Duration
00:04:39
00:00:58
00:03:18
00:04:02
The cells are custom formatted as hh:mm:ss. All I want to know is the
average length for those four calls. But when I try the AVERAGE function, I
get a DIV/0 error. Any ideas on what I'm doing wrong? Thanks in advance!
Your data is actually text that looks like time. Put the number 1 in a
currently blank cell. Copy that cell. Select your text "times". Edit / Paste
Special / Values / Multiply / OK.
|