How to work out weighted AHT in Excel

S

Si1209

Board Regular
Joined
Jan 27, 2016
Messages
50
Hi

I am after some help with calculating weighted average AHT.

I am doing a spreadsheet using CMS reports and need to calculate the average AHT from 2 reports. I am unable to run the report as 1 as too many lines are in the report. I need to convert the 2 reports in to 1 as part of the spreadsheet I am making.

Example 1
[TABLE="width: 1472"]
<colgroup><col style="width:48pt" span="23" width="64"> </colgroup><tbody>[TR]
[TD="class: xl1464, width: 64"]0800-2000[/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1464, width: 64"]Avg talk[/TD]
[TD="class: xl1464, width: 64"]Avg ACW[/TD]
[TD="class: xl1464, width: 64"]Avg Hold[/TD]
[TD="class: xl1464, width: 64"]Avg Wait[/TD]
[TD="class: xl1464, width: 64"]Max Wait[/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl1463, align: right"]2005[/TD]
[TD="class: xl1463, align: right"]1752[/TD]
[TD="class: xl1463, align: right"]47[/TD]
[TD="class: xl1463, align: right"]206[/TD]
[TD="class: xl1463, align: right"]10[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]193[/TD]
[TD="class: xl1463, align: right"]1096[/TD]
[TD="class: xl1463, align: right"]270[/TD]
[TD="class: xl1463, align: right"]36[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]489.5394[/TD]
[TD="class: xl1463, align: right"]1422.49[/TD]
[TD="class: xl1463, align: right"]152.4909[/TD]
[TD="class: xl1463, align: right"]250.0862[/TD]
[TD="class: xl1463, align: right"]1282[/TD]
[TD="class: xl1463, align: right"]1820[/TD]
[TD="class: xl1463, align: right"]233.9962[/TD]
[TD="class: xl1463, align: right"]41.9[/TD]
[TD="class: xl1463"] [/TD]
[TD="class: xl1463"] [/TD]
[TD="class: xl1463"] [/TD]
[TD="class: xl1463"] [/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]08:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]08:30[/TD]
[TD="class: xl1463, align: right"]6[/TD]
[TD="class: xl1463, align: right"]6[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]100[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]344[/TD]
[TD="class: xl1463, align: right"]306.1667[/TD]
[TD="class: xl1463, align: right"]129.3333[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]11[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]107[/TD]
[TD="class: xl1463, align: right"]26[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]08:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]09:00[/TD]
[TD="class: xl1463, align: right"]21[/TD]
[TD="class: xl1463, align: right"]20[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]95[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]300.1[/TD]
[TD="class: xl1463, align: right"]536.35[/TD]
[TD="class: xl1463, align: right"]128.4[/TD]
[TD="class: xl1463, align: right"]3.15[/TD]
[TD="class: xl1463, align: right"]22[/TD]
[TD="class: xl1463, align: right"]23[/TD]
[TD="class: xl1463, align: right"]167.087[/TD]
[TD="class: xl1463, align: right"]31[/TD]
[TD="class: xl1463, align: right"]3.15[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]09:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]09:30[/TD]
[TD="class: xl1463, align: right"]61[/TD]
[TD="class: xl1463, align: right"]56[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]5[/TD]
[TD="class: xl1463, align: right"]7[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]32[/TD]
[TD="class: xl1463, align: right"]9[/TD]
[TD="class: xl1463, align: right"]80[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]374.1786[/TD]
[TD="class: xl1463, align: right"]958.4643[/TD]
[TD="class: xl1463, align: right"]92.35714[/TD]
[TD="class: xl1463, align: right"]13.41071[/TD]
[TD="class: xl1463, align: right"]275[/TD]
[TD="class: xl1463, align: right"]38[/TD]
[TD="class: xl1463, align: right"]212.6579[/TD]
[TD="class: xl1463, align: right"]40.4[/TD]
[TD="class: xl1463, align: right"]13.41071[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]09:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]10:00[/TD]
[TD="class: xl1463, align: right"]81[/TD]
[TD="class: xl1463, align: right"]77[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463, align: right"]39[/TD]
[TD="class: xl1463, align: right"]13[/TD]
[TD="class: xl1463, align: right"]65[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]437.8052[/TD]
[TD="class: xl1463, align: right"]1221.974[/TD]
[TD="class: xl1463, align: right"]108.7533[/TD]
[TD="class: xl1463, align: right"]44.64935[/TD]
[TD="class: xl1463, align: right"]403[/TD]
[TD="class: xl1463, align: right"]78[/TD]
[TD="class: xl1463, align: right"]190.4744[/TD]
[TD="class: xl1463, align: right"]48[/TD]
[TD="class: xl1463, align: right"]44.64935[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]10:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]10:30[/TD]
[TD="class: xl1463, align: right"]89[/TD]
[TD="class: xl1463, align: right"]80[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]6[/TD]
[TD="class: xl1463, align: right"]7[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]6[/TD]
[TD="class: xl1463, align: right"]46[/TD]
[TD="class: xl1463, align: right"]9[/TD]
[TD="class: xl1463, align: right"]54[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]426.05[/TD]
[TD="class: xl1463, align: right"]1510.85[/TD]
[TD="class: xl1463, align: right"]125.25[/TD]
[TD="class: xl1463, align: right"]75.275[/TD]
[TD="class: xl1463, align: right"]542[/TD]
[TD="class: xl1463, align: right"]101[/TD]
[TD="class: xl1463, align: right"]228.2772[/TD]
[TD="class: xl1463, align: right"]56.2[/TD]
[TD="class: xl1463, align: right"]75.275[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]10:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]11:00[/TD]
[TD="class: xl1463, align: right"]124[/TD]
[TD="class: xl1463, align: right"]109[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]11[/TD]
[TD="class: xl1463, align: right"]9[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]11[/TD]
[TD="class: xl1463, align: right"]69[/TD]
[TD="class: xl1463, align: right"]13[/TD]
[TD="class: xl1463, align: right"]46[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]470.7339[/TD]
[TD="class: xl1463, align: right"]1335.716[/TD]
[TD="class: xl1463, align: right"]139.6789[/TD]
[TD="class: xl1463, align: right"]118.8899[/TD]
[TD="class: xl1463, align: right"]646[/TD]
[TD="class: xl1463, align: right"]100[/TD]
[TD="class: xl1463, align: right"]216.12[/TD]
[TD="class: xl1463, align: right"]57.4[/TD]
[TD="class: xl1463, align: right"]118.8899[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]11:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]11:30[/TD]
[TD="class: xl1463, align: right"]113[/TD]
[TD="class: xl1463, align: right"]101[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]9[/TD]
[TD="class: xl1463, align: right"]7[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]8[/TD]
[TD="class: xl1463, align: right"]70[/TD]
[TD="class: xl1463, align: right"]19[/TD]
[TD="class: xl1463, align: right"]38[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]487.4554[/TD]
[TD="class: xl1463, align: right"]1266.178[/TD]
[TD="class: xl1463, align: right"]168.3168[/TD]
[TD="class: xl1463, align: right"]166.5941[/TD]
[TD="class: xl1463, align: right"]703[/TD]
[TD="class: xl1463, align: right"]86[/TD]
[TD="class: xl1463, align: right"]244.407[/TD]
[TD="class: xl1463, align: right"]58.6[/TD]
[TD="class: xl1463, align: right"]166.5941[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]11:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]12:00[/TD]
[TD="class: xl1463, align: right"]120[/TD]
[TD="class: xl1463, align: right"]104[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]10[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]66[/TD]
[TD="class: xl1463, align: right"]16[/TD]
[TD="class: xl1463, align: right"]43[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]447.0096[/TD]
[TD="class: xl1463, align: right"]1258.25[/TD]
[TD="class: xl1463, align: right"]173.8558[/TD]
[TD="class: xl1463, align: right"]193.7692[/TD]
[TD="class: xl1463, align: right"]756[/TD]
[TD="class: xl1463, align: right"]117[/TD]
[TD="class: xl1463, align: right"]172.0427[/TD]
[TD="class: xl1463, align: right"]59.2[/TD]
[TD="class: xl1463, align: right"]193.7692[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]12:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]12:30[/TD]
[TD="class: xl1463, align: right"]129[/TD]
[TD="class: xl1463, align: right"]105[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463, align: right"]22[/TD]
[TD="class: xl1463, align: right"]16[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]20[/TD]
[TD="class: xl1463, align: right"]67[/TD]
[TD="class: xl1463, align: right"]23[/TD]
[TD="class: xl1463, align: right"]32[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]494.8191[/TD]
[TD="class: xl1463, align: right"]1479.162[/TD]
[TD="class: xl1463, align: right"]131.2286[/TD]
[TD="class: xl1463, align: right"]229.5714[/TD]
[TD="class: xl1463, align: right"]1067[/TD]
[TD="class: xl1463, align: right"]116[/TD]
[TD="class: xl1463, align: right"]231.0086[/TD]
[TD="class: xl1463, align: right"]59.3[/TD]
[TD="class: xl1463, align: right"]229.5714[/TD]
[/TR]
</tbody>[/TABLE]

Example 2
[TABLE="width: 1472"]
<colgroup><col style="width:48pt" span="23" width="64"> </colgroup><tbody>[TR]
[TD="class: xl1463, width: 64"]0800-2000[/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1464, width: 64"]Avg talk[/TD]
[TD="class: xl1464, width: 64"]Avg ACW[/TD]
[TD="class: xl1464, width: 64"]Avg Hold[/TD]
[TD="class: xl1464, width: 64"]Avg Wait[/TD]
[TD="class: xl1464, width: 64"]Max Wait[/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[TD="class: xl1463, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl1463, align: right"]1421[/TD]
[TD="class: xl1463, align: right"]1405[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]15[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]7[/TD]
[TD="class: xl1463, align: right"]1291[/TD]
[TD="class: xl1463, align: right"]1249[/TD]
[TD="class: xl1463, align: right"]92[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]82.98363[/TD]
[TD="class: xl1463, align: right"]94.07545[/TD]
[TD="class: xl1463, align: right"]15.5452[/TD]
[TD="class: xl1463, align: right"]10.66263[/TD]
[TD="class: xl1463, align: right"]610[/TD]
[TD="class: xl1463, align: right"]1327[/TD]
[TD="class: xl1463, align: right"]13.27581[/TD]
[TD="class: xl1463, align: right"]11.6[/TD]
[TD="class: xl1463"] [/TD]
[TD="class: xl1463"] [/TD]
[TD="class: xl1463"] [/TD]
[TD="class: xl1463"] [/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]08:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]08:30[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]100[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]57.25[/TD]
[TD="class: xl1463, align: right"]2.5[/TD]
[TD="class: xl1463, align: right"]10.75[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]41[/TD]
[TD="class: xl1463, align: right"]4.9[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]08:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]09:00[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]100[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]70.5[/TD]
[TD="class: xl1463, align: right"]5[/TD]
[TD="class: xl1463, align: right"]27.08333[/TD]
[TD="class: xl1463, align: right"]2.833333[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]12[/TD]
[TD="class: xl1463, align: right"]8.666667[/TD]
[TD="class: xl1463, align: right"]7.6[/TD]
[TD="class: xl1463, align: right"]2.833333[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]09:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]09:30[/TD]
[TD="class: xl1463, align: right"]38[/TD]
[TD="class: xl1463, align: right"]38[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]34[/TD]
[TD="class: xl1463, align: right"]34[/TD]
[TD="class: xl1463, align: right"]100[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]87.73684[/TD]
[TD="class: xl1463, align: right"]107.2368[/TD]
[TD="class: xl1463, align: right"]17.18421[/TD]
[TD="class: xl1463, align: right"]2.394737[/TD]
[TD="class: xl1463, align: right"]4[/TD]
[TD="class: xl1463, align: right"]38[/TD]
[TD="class: xl1463, align: right"]28.47368[/TD]
[TD="class: xl1463, align: right"]11.1[/TD]
[TD="class: xl1463, align: right"]2.394737[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]09:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]10:00[/TD]
[TD="class: xl1463, align: right"]63[/TD]
[TD="class: xl1463, align: right"]62[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]57[/TD]
[TD="class: xl1463, align: right"]55[/TD]
[TD="class: xl1463, align: right"]98[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]65[/TD]
[TD="class: xl1463, align: right"]55.24194[/TD]
[TD="class: xl1463, align: right"]21.56452[/TD]
[TD="class: xl1463, align: right"]3.080645[/TD]
[TD="class: xl1463, align: right"]23[/TD]
[TD="class: xl1463, align: right"]59[/TD]
[TD="class: xl1463, align: right"]30.47458[/TD]
[TD="class: xl1463, align: right"]13.2[/TD]
[TD="class: xl1463, align: right"]3.080645[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]10:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]10:30[/TD]
[TD="class: xl1463, align: right"]75[/TD]
[TD="class: xl1463, align: right"]75[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]69[/TD]
[TD="class: xl1463, align: right"]65[/TD]
[TD="class: xl1463, align: right"]99[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]95.86667[/TD]
[TD="class: xl1463, align: right"]156.6133[/TD]
[TD="class: xl1463, align: right"]22.04[/TD]
[TD="class: xl1463, align: right"]6.146667[/TD]
[TD="class: xl1463, align: right"]285[/TD]
[TD="class: xl1463, align: right"]68[/TD]
[TD="class: xl1463, align: right"]12.88235[/TD]
[TD="class: xl1463, align: right"]14.9[/TD]
[TD="class: xl1463, align: right"]6.146667[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]10:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]11:00[/TD]
[TD="class: xl1463, align: right"]82[/TD]
[TD="class: xl1463, align: right"]81[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]74[/TD]
[TD="class: xl1463, align: right"]66[/TD]
[TD="class: xl1463, align: right"]94[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]95.04939[/TD]
[TD="class: xl1463, align: right"]84.48148[/TD]
[TD="class: xl1463, align: right"]15.92593[/TD]
[TD="class: xl1463, align: right"]10.76543[/TD]
[TD="class: xl1463, align: right"]275[/TD]
[TD="class: xl1463, align: right"]79[/TD]
[TD="class: xl1463, align: right"]16.63291[/TD]
[TD="class: xl1463, align: right"]14.7[/TD]
[TD="class: xl1463, align: right"]10.76543[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]11:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]11:30[/TD]
[TD="class: xl1463, align: right"]98[/TD]
[TD="class: xl1463, align: right"]96[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]87[/TD]
[TD="class: xl1463, align: right"]84[/TD]
[TD="class: xl1463, align: right"]94[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]83.5[/TD]
[TD="class: xl1463, align: right"]145.8646[/TD]
[TD="class: xl1463, align: right"]18[/TD]
[TD="class: xl1463, align: right"]19.48958[/TD]
[TD="class: xl1463, align: right"]610[/TD]
[TD="class: xl1463, align: right"]90[/TD]
[TD="class: xl1463, align: right"]15.03333[/TD]
[TD="class: xl1463, align: right"]14.8[/TD]
[TD="class: xl1463, align: right"]19.48958[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]11:30[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]12:00[/TD]
[TD="class: xl1463, align: right"]85[/TD]
[TD="class: xl1463, align: right"]83[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]2[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]1[/TD]
[TD="class: xl1463, align: right"]76[/TD]
[TD="class: xl1463, align: right"]75[/TD]
[TD="class: xl1463, align: right"]98[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]74.98795[/TD]
[TD="class: xl1463, align: right"]121.1687[/TD]
[TD="class: xl1463, align: right"]17.08434[/TD]
[TD="class: xl1463, align: right"]3.710843[/TD]
[TD="class: xl1463, align: right"]133[/TD]
[TD="class: xl1463, align: right"]80[/TD]
[TD="class: xl1463, align: right"]16.6375[/TD]
[TD="class: xl1463, align: right"]14.8[/TD]
[TD="class: xl1463, align: right"]3.710843[/TD]
[/TR]
[TR]
[TD="class: xl1465, align: right"]12:00[/TD]
[TD="class: xl1463"]-[/TD]
[TD="class: xl1465, align: right"]12:30[/TD]
[TD="class: xl1463, align: right"]86[/TD]
[TD="class: xl1463, align: right"]83[/TD]
[TD="class: xl1463, align: right"]0[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]3[/TD]
[TD="class: xl1463, align: right"]76[/TD]
[TD="class: xl1463, align: right"]74[/TD]
[TD="class: xl1463, align: right"]93[/TD]
[TD="class: xl1463"]%[/TD]
[TD="class: xl1463, align: right"]102.5301[/TD]
[TD="class: xl1463, align: right"]96.28915[/TD]
[TD="class: xl1463, align: right"]15.6506[/TD]
[TD="class: xl1463, align: right"]7.506024[/TD]
[TD="class: xl1463, align: right"]296[/TD]
[TD="class: xl1463, align: right"]79[/TD]
[TD="class: xl1463, align: right"]14.56962[/TD]
[TD="class: xl1463, align: right"]14.9[/TD]
[TD="class: xl1463, align: right"]7.506024[/TD]
[/TR]
</tbody>[/TABLE]

So my AHT needs to include Avg ACW Avg Talk Avg Hold and I can work that out but I just dont know how to make it weighted when all the calls are converted in to one table.

Any help would be massively appreciated.

Thanks
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
Re: How to work out weughted AHT in Excel

what is AHT? ACW Hold Talk? what does "AHT needs to include Avg ACW Avg Talk Avg Hold" mean?

but anyways just do... {SUM(Weights * values)} -> {Sum(counts / total count * values)}
 
Last edited:
Upvote 0
Re: How to work out weughted AHT in Excel

Sorry for the late response. This might be me being stupid but, with that above formula, how would I work out the Average Handling Time based on the below?

Calls AHT
15 1020
22 1516
27 1122
28 1348
32 1478
16 1257


Calls AHT
19 1453
17 1487
18 1645
23 1594
14 1788
15 1357

So if I'm wanting to work out the overall average AHT for the 2 tables combined how would I do this with that above formula? I'm pretty much a novice on Excel and trying to work out all this so sorry for seeming simple
[TABLE="width: 87"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 87"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Calculate hour total for each week
2
Replies
16
Views
269
CaptainGravyBum
C
C
  • Question Question
TIME LIMITATIONS
Replies
1
Views
212
cooleomter
C
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
525
dshtesy
D
M
  • Question Question
Pivot table and calculation issues
Replies
1
Views
200
RoryA
RoryA
V
  • Solved
vlookup not working in some case
Replies
4
Views
89
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,226,698
Messages
6,192,514
Members
453,728
Latest member
Ishtiak Mahmud

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top