Calculation Question

M

Mary C

Ok here goes I have to calulate this for a month and can not come up with how
to do it so any help will be great.

Dept Ansd Calls Average time to Answer
2 247 0:00:06
3 133 0:00:33
4 59 0:00:08
5 586 0:00:32
6 3202 0:01:25
totals: 4227
I need an average time the total calls were answered in
I think I am dense but can not come up with a calculation

Thanks for your help.
 
B

Bob I

add up("Ansd Calls" times "Average time to Answer") for all the dept and
then divide by the total "Ansd Calls"
 
G

Gary''s Student

Assuming the numbers are in column B and the times (minutes:seconds) are in
column C:

=SUMPRODUCT(B2:B6,C2:C6)/SUM(B2:B6)

formatted as [mm]:ss this will display as:

01:10
 
M

Mary C

Thanks for your help, the formula worked wonderfully and I am now a happy
camper!
--
Mary C


Gary''s Student said:
Assuming the numbers are in column B and the times (minutes:seconds) are in
column C:

=SUMPRODUCT(B2:B6,C2:C6)/SUM(B2:B6)

formatted as [mm]:ss this will display as:

01:10

--
Gary''s Student - gsnu200783


Mary C said:
Ok here goes I have to calulate this for a month and can not come up with how
to do it so any help will be great.

Dept Ansd Calls Average time to Answer
2 247 0:00:06
3 133 0:00:33
4 59 0:00:08
5 586 0:00:32
6 3202 0:01:25
totals: 4227
I need an average time the total calls were answered in
I think I am dense but can not come up with a calculation

Thanks for your help.
Click to expand...
Click to expand...
 
Top