Spreadsheet: 115737d1311258795-trying-to-combine-data-from-2-tables-agent-list
Sheet: Sheet1

 |  |  |  |  |  |  | Handle Time |  | Talk Time |  | Hold Time |  | Work Time |  | Idle Time
Month | Agent Name | Extension | Average*  Logged-In  Time | Calls Handled | Calls  Presented | Handle Ratio | Avg | [NAME] | Avg | [NAME] | Avg | [NAME] | Avg | [NAME] | Avg* | [NAME]
2011-06-01 00:00:00 | Agent 1 | 1816 | 05:27:10 | 34 | 39 | 0.87 | 0:08:04 | 01:28:38 | 0:07:46 | 01:28:38 | 0:00:18 | 0:04:00 | 0:00:00 | 0:00:00 | 0:13:18 | 01:03:04
2011-06-01 00:00:00 | Agent 2 | 1844 | 06:29:55 | 18 | 37 | 0.49 | 0:04:17 | 0:18:42 | 0:04:11 | 0:18:42 | 0:00:06 | 0:01:04 | 0:00:00 | 0:00:00 | 0:02:59 | 0:11:56
2011-06-01 00:00:00 | Agent 3 | 1867 | 05:12:09 | 68 | 78 | 0.87 | 0:02:11 | 0:23:40 | 0:02:11 | 0:23:40 | 0:00:00 | 0:00:20 | 0:00:00 | 0:00:00 | 0:25:26 | 14:42:51
2011-06-01 00:00:00 | Agent 4 | 1841 | 06:46:13 | 37 | 37 | 1 | 0:04:41 | 01:02:14 | 0:04:25 | 01:02:14 | 0:00:16 | 0:05:39 | 0:00:00 | 0:00:00 | 0:41:53 | 13:32:38
2011-06-01 00:00:00 | Agent 5 | 1836 | 07:08:37 | 68 | 70 | 0.97 | 0:02:45 | 0:23:42 | 0:02:42 | 0:23:42 | 0:00:02 | 0:02:05 | 0:00:00 | 0:00:00 | 0:19:43 | 14:20:17
2011-06-01 00:00:00 | Agent 6 | 1818 | 06:05:53 | 82 | 98 | 0.84 | 0:02:38 | 0:22:43 | 0:02:36 | 0:22:43 | 0:00:01 | 0:00:46 | 0:00:00 | 0:00:00 | 0:07:08 | 01:29:37
2011-06-01 00:00:00 | Agent 7 | 1830 | 08:51:38 | 13 | 14 | 0.93 | 0:02:35 | 0:07:30 | 0:02:35 | 0:07:30 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:33:21 | 01:35:30
2011-06-01 00:00:00 | Agent 8 | 1864 | 08:00:27 | 46 | 54 | 0.85 | 0:04:04 | 0:17:22 | 0:04:04 | 0:17:22 | 0:00:00 | 0:00:15 | 0:00:00 | 0:00:00 | 0:24:48 | 13:31:03
2011-06-01 00:00:00 | Agent 9 | 1831 | 06:03:29 | 72 | 83 | 0.87 | 0:03:12 | 0:17:37 | 0:03:10 | 0:17:37 | 0:00:01 | 0:01:04 | 0:00:00 | 0:00:00 | 0:23:21 | 13:20:42
2011-06-01 00:00:00 | Agent 10 | 1843 | 07:41:47 | 13 | 23 | 0.57 | 0:02:26 | 0:08:18 | 0:02:21 | 0:08:18 | 0:00:05 | 0:00:36 | 0:00:00 | 0:00:00 | 0:14:28 | 01:25:49
2011-06-01 00:00:00 | Agent 11 | 1854 | 05:29:04 | 65 | 68 | 0.96 | 0:04:52 | 0:36:56 | 0:04:33 | 0:36:56 | 0:00:19 | 0:13:29 | 0:00:00 | 0:00:00 | 0:09:50 | 0:52:42
2011-06-01 00:00:00 | Agent 12 | 1402 | 05:58:40 | 2 | 3 | 0.67 | 0:03:29 | 0:05:32 | 0:03:29 | 0:05:32 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 01:21:48 | 07:46:05
2011-06-01 00:00:00 | Agent 1 | 1816 | 07:16:11 | 259 | 272 | 0.95 | 0:07:09 | 01:07:12 | 0:06:47 | 01:06:52 | 0:00:07 | 0:05:28 | 0:00:14 | 0:00:20 | 0:14:09 | 01:16:15
2011-06-01 00:00:00 | Agent 2 | 1844 | 07:34:30 | 127 | 141 | 0.9 | 0:04:00 | 0:32:15 | 0:03:16 | 0:28:12 | 0:00:43 | 0:15:15 | 0:00:00 | 0:00:00 | 0:05:59 | 02:01:06
2011-06-01 00:00:00 | Agent 3 | 1867 | 07:41:35 | 286 | 315 | 0.91 | 0:04:10 | 01:01:27 | 0:03:47 | 01:01:11 | 0:00:07 | 0:09:29 | 0:00:15 | 0:00:20 | 0:12:05 | 01:09:15
2011-06-01 00:00:00 | Agent 4 | 1841 | 09:27:21 | 207 | 214 | 0.97 | 0:04:24 | 0:59:36 | 0:03:43 | 0:55:26 | 0:00:26 | 0:09:00 | 0:00:14 | 0:00:20 | 0:15:02 | 14:59:13
2011-06-01 00:00:00 | Agent 5 | 1836 | [NAME] | 386 | 399 | 0.97 | 0:03:36 | 0:57:55 | 0:03:33 | 0:57:55 | 0:00:03 | 0:04:37 | 0:00:00 | 0:00:00 | 0:07:22 | [NAME]
2011-06-01 00:00:00 | Agent 6 | 1818 | 07:26:53 | 175 | 205 | 0.85 | 0:03:44 | 0:36:55 | 0:03:42 | 0:36:55 | 0:00:02 | 0:01:26 | 0:00:00 | 0:00:00 | 0:07:09 | 01:38:54
2011-06-01 00:00:00 | Agent 7 | 1830 | 08:32:36 | 95 | 105 | 0.9 | 0:03:57 | 0:30:19 | 0:03:55 | 0:30:19 | 0:00:02 | 0:02:55 | 0:00:00 | 0:00:05 | 0:08:55 | 01:44:26
2011-06-01 00:00:00 | Agent 8 | 1864 | 08:00:39 | 155 | 212 | 0.73 | 0:06:33 | [NAME] | 0:06:31 | [NAME] | 0:00:02 | 0:03:19 | 0:00:00 | 0:00:00 | 0:11:14 | 02:02:44
2011-06-01 00:00:00 | Agent 9 | 1831 | 06:48:52 | 274 | 278 | 0.99 | 0:06:03 | 0:55:37 | 0:05:46 | 0:55:32 | 0:00:02 | 0:04:31 | 0:00:14 | 0:00:20 | 0:14:41 | 03:52:20
2011-06-01 00:00:00 | Agent 10 | 1843 | 06:16:28 | 60 | 74 | 0.81 | 0:02:57 | 0:22:15 | 0:02:46 | 0:20:42 | 0:00:10 | 0:04:58 | 0:00:01 | 0:00:20 | 0:13:01 | 02:00:20
2011-06-01 00:00:00 | Agent 11 | 1854 | 743:59:59 | 0 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
2011-06-01 00:00:00 | Agent 11 | 1854 | 0:00:00 | 0 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
2011-06-01 00:00:00 | Agent 11 | 1854 | 0:00:00 | 0 | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00
2011-06-01 00:00:00 | Agent 11 | 1854 | 05:36:38 | 469 | 488 | 0.96 | 0:03:55 | [NAME] | 0:03:48 | [NAME] | 0:00:07 | 0:06:28 | 0:00:00 | 0:00:00 | 0:06:17 | 01:14:29
2011-06-01 00:00:00 | Agent 12 | 1402 | [NAME] | 36 | 47 | 0.77 | [NAME] | 0:19:44 | 0:03:53 | 0:19:44 | 0:00:08 | 0:03:20 | 0:00:00 | 0:00:00 | 01:04:55 | 18:48:12