Call_Volume_Trend_Analysis_Project_9.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Agent_Name	Agent_ID	Customer_Phone_No	Queue_Time(Secs)	Date_&_Time	Time	Time_Bucket	Duration(hh:mm:ss)	Call_Seconds (s)	Call_Status	Wrapped _By	Ringing	IVR _Duration
2	Executives 42	1000042	98502XXXXX	2	1/1/2022	9.00	9_10	0:01:36	96.00	answered	Agent	YES	0:00:16
3	Executives 4	1000004	80595XXXXX	0	1/1/2022	9.00	9_10	0:02:20	140.00	answered	Agent	YES	0:00:26
4	Executives 65	1000065	70202XXXXX	0	1/1/2022	9.00	9_10	0:01:25	85.00	answered	AutoWrapped	YES	0:00:16
5	Executives 55	1000055	96104XXXXX	1	1/1/2022	9.00	9_10	0:01:31	91.00	answered	Agent	YES	0:00:25
6	Executives 21	1000021	82001XXXXX	0	1/1/2022	9.00	9_10	0:02:45	165.00	answered	Agent	YES	0:00:23
7	#N/A	#N/A	96424XXXXX	13	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:16
8	Executives 55	1000055	96737XXXXX	79	1/1/2022	9.00	9_10	0:01:25	85.00	answered	AutoWrapped	YES	0:00:13
9	#N/A	#N/A	96392XXXXX	60	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:17
10	Executives 42	1000042	90820XXXXX	52	1/1/2022	9.00	9_10	0:01:05	65.00	answered	Agent	YES	0:00:20
11	Executives 65	1000065	97410XXXXX	62	1/1/2022	9.00	9_10	0:03:00	180.00	answered	AutoWrapped	YES	0:00:44
12	Executives 4	1000004	70076XXXXX	52	1/1/2022	9.00	9_10	0:01:48	108.00	answered	Agent	YES	0:00:15
13	Executives 21	1000021	82505XXXXX	89	1/1/2022	9.00	9_10	0:03:06	186.00	answered	Agent	YES	0:00:16
14	#N/A	#N/A	97232XXXXX	120	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:40
15	Executives 55	1000055	96392XXXXX	45	1/1/2022	9.00	9_10	0:01:40	100.00	answered	AutoWrapped	YES	0:00:42
16	Executives 42	1000042	97471XXXXX	55	1/1/2022	9.00	9_10	0:01:15	75.00	answered	AutoWrapped	YES	0:00:19
17	#N/A	#N/A	77082XXXXX	16	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:18
18	#N/A	#N/A	95255XXXXX	44	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:17
19	Executives 4	1000004	79725XXXXX	88	1/1/2022	9.00	9_10	0:04:03	243.00	answered	AutoWrapped	YES	0:00:15
20	Executives 49	1000049	98344XXXXX	46	1/1/2022	9.00	9_10	0:04:10	250.00	answered	Agent	YES	0:00:19
21	Executives 50	1000050	96873XXXXX	64	1/1/2022	9.00	9_10	0:03:28	208.00	answered	Agent	YES	0:00:48
22	Executives 42	1000042	79899XXXXX	52	1/1/2022	9.00	9_10	0:02:34	154.00	answered		YES	0:00:26
23	Executives 65	1000065	95754XXXXX	67	1/1/2022	9.00	9_10	0:02:07	127.00	answered	AutoWrapped	YES	0:00:45
24	Executives 55	1000055	70546XXXXX	64	1/1/2022	9.00	9_10	0:03:11	191.00	answered	AutoWrapped	YES	0:00:40
25	Executives 21	1000021	97050XXXXX	47	1/1/2022	9.00	9_10	0:03:23	203.00	answered	Agent	YES	0:00:25
26	#N/A	#N/A	89680XXXXX	120	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:25
27	Executives 59	1000059	99954XXXXX	75	1/1/2022	9.00	9_10	0:02:30	150.00	answered	AutoWrapped	YES	0:00:21
28	Executives 16	1000016	90074XXXXX	71	1/1/2022	9.00	9_10	0:04:13	253.00	answered	Agent	YES	0:00:20
29	#N/A	#N/A	96048XXXXX	65	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:17
30	Executives 42	1000042	99971XXXXX	27	1/1/2022	9.00	9_10	0:00:44	44.00	answered	Agent	YES	0:00:16
31	Executives 65	1000065	63523XXXXX	36	1/1/2022	9.00	9_10	0:01:27	87.00	answered		YES	0:00:17
32	Executives 50	1000050	99824XXXXX	36	1/1/2022	9.00	9_10	0:01:16	76.00	answered	AutoWrapped	YES	0:00:17
33	Executives 42	1000042	93684XXXXX	50	1/1/2022	9.00	9_10	0:02:44	164.00	answered	Agent	YES	0:00:41
34	Executives 4	1000004	91057XXXXX	42	1/1/2022	9.00	9_10	0:03:25	205.00	answered	Agent	YES	0:00:46
35	Executives 21	1000021	62807XXXXX	0	1/1/2022	9.00	9_10	0:00:54	54.00	answered	AutoWrapped	YES	0:00:42
36	Executives 55	1000055	92257XXXXX	17	1/1/2022	9.00	9_10	0:02:11	131.00	answered	AutoWrapped	YES	0:00:17
37	Executives 65	1000065	88010XXXXX	10	1/1/2022	9.00	9_10	0:02:06	126.00	answered	Agent	YES	0:00:42
38	#N/A	#N/A	87782XXXXX	16	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:17
39	Executives 50	1000050	97600XXXXX	20	1/1/2022	9.00	9_10	0:02:12	132.00	answered		YES	0:00:17
40	Executives 59	1000059	70510XXXXX	5	1/1/2022	9.00	9_10	0:01:58	118.00	answered		YES	0:00:16
41	Executives 21	1000021	72238XXXXX	5	1/1/2022	9.00	9_10	0:05:17	317.00	answered		YES	0:00:28
42	#N/A	#N/A	87782XXXXX	16	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:16
43	Executives 49	1000049	84488XXXXX	31	1/1/2022	9.00	9_10	0:04:12	252.00	answered	Agent	YES	0:00:17
44	#N/A	#N/A	87782XXXXX	16	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:16
45	Executives 65	1000065	97559XXXXX	66	1/1/2022	9.00	9_10	0:01:28	88.00	answered	Agent	YES	0:00:21
46	Executives 16	1000016	88258XXXXX	76	1/1/2022	9.00	9_10	0:00:46	46.00	answered	Agent	YES	0:00:39
47	Executives 42	1000042	94154XXXXX	75	1/1/2022	9.00	9_10	0:00:41	41.00	answered	Agent	YES	0:00:19
48	Executives 55	1000055	73557XXXXX	77	1/1/2022	9.00	9_10	0:02:59	179.00	answered		YES	0:00:21
49	Executives 60	1000060	82694XXXXX	76	1/1/2022	9.00	9_10	0:02:30	150.00	answered	Agent	YES	0:01:44
50	Executives 59	1000059	81798XXXXX	47	1/1/2022	9.00	9_10	0:01:23	83.00	answered	Agent	YES	0:00:25
51	Executives 50	1000050	86002XXXXX	27	1/1/2022	9.00	9_10	0:02:25	145.00	answered	Agent	YES	0:00:26
52	Executives 42	1000042	97232XXXXX	2	1/1/2022	9.00	9_10	0:01:27	87.00	answered	Agent	YES	0:00:13
53	Executives 4	1000004	94154XXXXX	1	1/1/2022	9.00	9_10	0:03:39	219.00	answered	Agent	YES	0:00:40
54	Executives 16	1000016	77289XXXXX	0	1/1/2022	9.00	9_10	0:01:24	84.00	answered	Agent	YES	0:00:17
55	Executives 65	1000065	87782XXXXX	0	1/1/2022	9.00	9_10	0:00:10	10.00	answered	AutoWrapped	YES	0:00:23
56	Executives 59	1000059	76079XXXXX	26	1/1/2022	9.00	9_10	0:03:26	206.00	answered	AutoWrapped	YES	0:00:16
57	Executives 42	1000042	95636XXXXX	17	1/1/2022	9.00	9_10	0:01:45	105.00	answered	Agent	YES	0:00:13
58	#N/A	#N/A	87782XXXXX	7	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:26
59	Executives 65	1000065	89793XXXXX	21	1/1/2022	9.00	9_10	0:01:17	77.00	answered	Agent	YES	0:00:26
60	Executives 16	1000016	99971XXXXX	0	1/1/2022	9.00	9_10	0:01:31	91.00	answered	Agent	YES	0:00:17
61	Executives 55	1000055	94373XXXXX	0	1/1/2022	9.00	9_10	0:02:58	178.00	answered	Agent	YES	0:00:16
62	Executives 60	1000060	73557XXXXX	1	1/1/2022	9.00	9_10	0:02:03	123.00	answered	Agent	YES	0:00:17
63	Executives 50	1000050	72074XXXXX	0	1/1/2022	9.00	9_10	0:01:56	116.00	answered	Agent	YES	0:00:16
64	Executives 21	1000021	87782XXXXX	2	1/1/2022	9.00	9_10	0:00:08	8.00	answered		YES	0:00:23
65	Executives 49	1000049	93408XXXXX	2	1/1/2022	9.00	9_10	0:02:31	151.00	answered	AutoWrapped	YES	0:00:21
66	Executives 21	1000021	83690XXXXX	1	1/1/2022	9.00	9_10	0:01:38	98.00	answered	Agent	YES	0:00:15
67	Executives 6	1000006	92841XXXXX	1	1/1/2022	9.00	9_10	0:01:45	105.00	answered	AutoWrapped	YES	0:00:18
68	Executives 42	1000042	70520XXXXX	2	1/1/2022	9.00	9_10	0:02:55	175.00	answered	AutoWrapped	YES	0:00:16
69	Executives 16	1000016	96949XXXXX	0	1/1/2022	9.00	9_10	0:02:09	129.00	answered	Agent	YES	0:00:26
70	Executives 65	1000065	91107XXXXX	2	1/1/2022	9.00	9_10	0:03:13	193.00	answered	AutoWrapped	YES	0:00:16
71	Executives 60	1000060	80182XXXXX	0	1/1/2022	9.00	9_10	0:01:51	111.00	answered	AutoWrapped	YES	0:00:44
72	Executives 4	1000004	96107XXXXX	1	1/1/2022	9.00	9_10	0:03:54	234.00	answered	AutoWrapped	YES	0:00:18
73	Executives 55	1000055	95025XXXXX	0	1/1/2022	9.00	9_10	0:02:46	166.00	answered	AutoWrapped	YES	0:00:45
74	Executives 50	1000050	82995XXXXX	1	1/1/2022	9.00	9_10	0:03:04	184.00	answered	Agent	YES	0:00:20
75	Executives 59	1000059	98922XXXXX	6	1/1/2022	9.00	9_10	0:01:48	108.00	answered	Agent	YES	0:00:41
76	Executives 21	1000021	97909XXXXX	10	1/1/2022	9.00	9_10	0:02:36	156.00	answered	Agent	YES	0:00:17
77	Executives 6	1000006	84109XXXXX	62	1/1/2022	9.00	9_10	0:02:11	131.00	answered	AutoWrapped	YES	0:00:18
78	#N/A	#N/A	76229XXXXX	44	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:44
79	Executives 16	1000016	89435XXXXX	68	1/1/2022	9.00	9_10	0:04:37	277.00	answered	Agent	YES	0:00:16
80	Executives 49	1000049	84693XXXXX	76	1/1/2022	9.00	9_10	0:02:48	168.00	answered	AutoWrapped	YES	0:00:18
81	Executives 59	1000059	94453XXXXX	18	1/1/2022	9.00	9_10	0:00:58	58.00	answered	AutoWrapped	YES	0:00:18
82	Executives 60	1000060	70127XXXXX	25	1/1/2022	9.00	9_10	0:03:37	217.00	answered	Agent	YES	0:00:17
83	Executives 42	1000042	95255XXXXX	35	1/1/2022	9.00	9_10	0:02:37	157.00	answered		YES	0:00:26
84	Executives 21	1000021	99117XXXXX	48	1/1/2022	9.00	9_10	0:01:55	115.00	answered	AutoWrapped	YES	0:00:25
85	Executives 55	1000055	96149XXXXX	59	1/1/2022	9.00	9_10	0:00:17	17.00	answered		YES	0:00:42
86	Executives 65	1000065	70546XXXXX	66	1/1/2022	9.00	9_10	0:06:27	387.00	answered	AutoWrapped	YES	0:00:16
87	Executives 55	1000055	74998XXXXX	61	1/1/2022	9.00	9_10	0:02:07	127.00	answered	AutoWrapped	YES	0:00:21
88	Executives 50	1000050	85609XXXXX	58	1/1/2022	9.00	9_10	0:03:27	207.00	answered	AutoWrapped	YES	0:00:49
89	Executives 59	1000059	99249XXXXX	17	1/1/2022	9.00	9_10	0:01:30	90.00	answered	Agent	YES	0:00:18
90	Executives 6	1000006	95739XXXXX	10	1/1/2022	9.00	9_10	0:05:06	306.00	answered		YES	0:00:41
91	Executives 4	1000004	96670XXXXX	14	1/1/2022	9.00	9_10	0:04:05	245.00	answered	AutoWrapped	YES	0:00:26
92	Executives 59	1000059	96097XXXXX	54	1/1/2022	9.00	9_10	0:02:30	150.00	answered	AutoWrapped	YES	0:00:46
93	Executives 49	1000049	86391XXXXX	31	1/1/2022	9.00	9_10	0:02:45	165.00	answered	AutoWrapped	YES	0:00:23
94	Executives 42	1000042	98295XXXXX	27	1/1/2022	9.00	9_10	0:02:02	122.00	answered	AutoWrapped	YES	0:00:41
95	Executives 21	1000021	99404XXXXX	20	1/1/2022	9.00	9_10	0:03:59	239.00	answered	AutoWrapped	YES	0:00:16
96	Executives 60	1000060	99168XXXXX	33	1/1/2022	9.00	9_10	0:02:32	152.00	answered	Agent	YES	0:00:14
97	Executives 55	1000055	83413XXXXX	37	1/1/2022	9.00	9_10	0:03:22	202.00	answered		YES	0:00:42
98	#N/A	#N/A	85532XXXXX	50	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:15
99	#N/A	#N/A	70076XXXXX	45	1/1/2022	9.00	9_10	0:00:00	0.00	abandon		YES	0:00:18
100	Executives 51	1000051	98468XXXXX	83	1/1/2022	9.00	9_10	0:03:11	191.00	answered	Agent	YES	0:00:24