Convert Calls Intervals

[epadron54]

Hi

have a question related to covert number of calls from a cumulative total per day to a calls per hour like this.... Calls that need to be converted to hourly are on cells B3 to G23.

As example we take B3 = 25 and try to split on cells B12 to B14 with this formula =REDONDEAR.MENOS(($K12*$B$3)/$L$1,0) , but the split sums more calls than the original 25 (in this case 30, 5 more). the only way to adjust is changing in formula the value of $L$1 to the proper one, if decrese the value are more calls, if increase the value are less calls wich toke memore time to adjust based on have to do for the rest of the year. With the correct value I can compute the agents with erlang C formula.

I f anyone can take a look and give a solution will be highly appreciatted.

Regards
EP

LLAMADAS.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1											AHT	150	% SL	80	HOLD	20
2	ABRIL	Lunes	Martes	Miercoles	Jueves	Viernes	Sabado	TOTAL
3	09:00 -12:00	25	76	69	69	87	66	392
4	12:01 -15:00	105	304	278	254	309	233	1483
5	15:01 -18:00	38	114	103	104	131	99	589
6	18:01 -21:00	78	228	207	235	309	233	1290
7	21:01 -23:00	12	38	34	34	42	32	192
8		258	760	691	696	878	663	3946
9
10	LLAMADAS
11	ABRIL	Lunes	Martes	Miercoles	Jueves	Viernes	Sabado	TOTAL		DISTRIBUCION
12	09:00 -09:59	5						5		09:00-09:59	30
13	10:00-10:59	10						10		10:00-10:59	60
14	11:00-11:59	15						15		11:00-11:59	90
15	12:00 -12:59									12:00-12:59	30
16	13:00-13:59									13:00-13:59	60
17	14:00-14:59									14:00-14:59	90
18	15:00-15:59									15:00-15:59	30
19	16:00-16:59									16:00-16:59	60
20	17:00-17:59									17:00-17:59	90
21	18:00-18:59									18:00-18:59	30
22	19:00 -19:59									19:00-19:59	60
23	20:00 -20:59									20:00-20:59	90
24	21:00 -21:59									21:00-21:59	30
25	22:00 -23:00									22:00-23:00	60
26		30	0	0	0	0	0	30
DISTRIBUCION LLAMADAS

Cell Formulas
Range	Formula
H3:H7,H26,H12:H14	H3	=SUM(B3:G3)
B8:H8	B8	=SUM(B3:B7)
B12:B14	B12	=ROUNDDOWN(($K12*$B$3)/$L$1,0)
B26:G26	B26	=SUM(B12:B25)