Thank you. We did consider incoming calls as well for it is an account
management position. we removed all personal calls. thanks for confirming
that value is correct.

"Pete_UK" wrote:

Slight flaw in your approach? Presumably this is a list of calls that
your company is charged for (i.e. outgoing calls) but your workers
will also receive incoming calls, and therefore spend longer on the
phone ...

If you divide this total by the number of working days and format the
cell in Excel time format then you should get 1:19:44 - the formula is
=A1/110, where A1 contains 146:09:49.

Hope this helps.

Pete

On Sep 25, 8:28 pm, dj479794
wrote:
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec.
Example:

0:11:34
1:04:45
...

if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take
the number of days that the person worked (110) during this data set to find
an average time per day on the phone.

I don't think I am getting the correct output:

Suggestions?