Reverse Weighted AHT Formula Help

[Marklarbear]

Hi Brains Trust

I'll premise this by letting you know I'm coming from a call centre environment....

What I would like to achieve is to reverse calculate weighted AHT (AHT - Average Handle Time). I have skill set A (volume & AHT) and skill set B (volume & AHT). Using standard call centre maths, I can calculate a Combined Volume and a Combined Weighted AHT.

What I want to do is calculate what the AHT would be for skill set A and skills set B if I have the the combined Volume and AHT, BUT ONLY the volumes for skills set A and skill set B....

Book1
	A	B	C
1	Combined Skills
2	Volume	AHT
3	327	664
4
5
6	Skill 1
7	Volume	AHT
8	125	640
9
10
11	Skill 2
12	Volume	AHT
13	202	679
14
15
16
17	Calculation A
18	Volume	AHT
19	327	664
20
21
22	Calculation B
23	Volume	AHT
24	125		?
25
26
27	Calculation C
28	Volume	AHT
29	202		?
30
Sheet1

Cell Formulas
Range	Formula
A19	A19	=A8+A13
B19	B19	=(SUMPRODUCT(A8*B8+A13*B13)/SUM(A8,A13))

 

[Marklarbear]

no one?????

 

[StephenCrump]

The question as posed has insufficient constraints for a unique solution.

Here's one solution showing how the two AHT's are related:

	A	B
1	Calculation A
2	Volume	AHT
3	327	664.091743
4
5
6	Calculation B
7	Volume	AHT
8	125	123
9
10
11	Calculation C
12	Volume	AHT
13	202	998.925743
14
15
16	Combined
17	Volume	AHT
18	327	664.091743
Sheet1

Cell Formulas
Range	Formula
B13	B13	=(A3*B3-A8*B8)/A13
A18	A18	=A13+A8
B18	B18	=(A8*B8+A13*B13)/A18