Spreadsheet: 55759d1255960690-excel-2007-adding-time-in-excel-book2
Sheet: Sheet1

Agent | Logon | inbound |  |  |  | ACD Inc. | Average | ACD | ACD  Int. | Average | Total | Work | Average | Total | Break | Average | Total | PBX Inc. | Average | PBX | [NAME]. | Average | Total | PBX Out | Average | Total
# Ans. | Duration | talk time |  |  |  | Talk Dur | # Ans. | TALK DUR | Count | Talk Dur | Duration | Count | Duration | Duration |  |  |  | Talk Dur | Talk Dur | TALK DUR | Talk Dur | Talk Dur | # Made | Duration | Duration
A | 162:46:25 |  |  |  |  | 271 | 00:02:54 | 13:05:39 | 1 | 00:02:05 | 00:02:05 | 1339 | 00:03:51 | 85:53:20 | 91 | 00:26:35 | 40:19:22 | 195 | 00:04:59 | 16:13:12 | 121 | 00:02:22 | [NAME] | 965 | 00:02:18 | 37:04:47
B | 157:59:47 |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 12 | 00:00:02 | [NAME] | 15 | 10:31:56 | 157:58:58 | 30 | 00:05:15 | 02:37:27 | 78 | 00:01:56 | 02:31:05 | 439 | 00:02:21 | 17:11:02
C | 00:07:12 |  |  |  |  | 452 | 00:00:00 | 0:00:00 | 0 | 00:00:00 | 00:00:00 | 2 | 00:00:04 | 00:00:08 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
D | 154:44:13 |  |  |  |  | 151 | 00:04:51 | 12:13:01 | 0 | 00:00:00 | 00:00:00 | 1307 | 00:03:37 | 78:36:59 | 21 | 01:03:03 | 22:04:09 | 140 | 00:04:53 | 11:22:42 | 91 | 00:02:02 | 03:05:37 | 803 | 00:02:21 | 31:26:23
E | 171:44:14 |  |  |  |  | 244 | 00:04:18 | 17:29:09 | 1 | 00:00:00 | 00:00:00 | 899 | [NAME] | 38:00:39 | 134 | 00:20:05 | 44:50:59 | 158 | 00:04:14 | 11:08:23 | 71 | 00:01:45 | 02:04:08 | 614 | 00:02:35 | 26:24:46
F | 218:37:46 |  |  |  |  | 297 | 00:04:15 | 21:00:47 | 1 | 00:01:01 | 00:01:01 | 871 | 00:07:09 | 103:49:26 | 89 | 00:18:21 | 27:13:53 | 197 | [NAME] | 15:36:38 | 107 | 00:02:02 | 03:37:11 | 562 | 00:02:09 | 20:05:22
G | 177:27:39 |  |  |  |  | 202 | 00:03:45 | [NAME] | 0 | 00:00:00 | 00:00:00 | 601 | 00:09:04 | [NAME] | 19 | 01:11:19 | 22:35:04 | 156 | 00:05:17 | 13:44:08 | 61 | 00:02:01 | [NAME] | 277 | [NAME] | 13:07:47
H | 13:04:30 |  |  |  |  | 169 | 00:02:59 | 08:24:45 | 0 | 00:00:00 | 00:00:00 | 12896 | 00:00:01 | 04:39:45 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
I | 174:45:50 |  |  |  |  | 106 | 00:06:16 | 11:04:39 | 0 | 00:00:00 | 00:00:00 | 1136 | 00:02:38 | 49:56:58 | 78 | 00:24:39 | 32:02:16 | 187 | 00:04:33 | 14:12:03 | 71 | 00:01:29 | 01:45:30 | 788 | 00:02:41 | 35:12:40
J | 00:05:01 |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 8 | 00:00:38 | 00:05:01 | 0 | 00:00:00 | 00:00:00 | 1 | 00:00:05 | 00:00:05 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
K | 36:37:15 |  |  |  |  | 395 | 00:02:34 | 16:55:15 | 2 | 00:00:15 | 00:00:30 | 26546 | 00:00:03 | 19:42:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
L | 179:09:22 |  |  |  |  | 136 | 00:05:08 | 11:37:08 | 0 | 00:00:00 | 00:00:00 | 1309 | 00:03:14 | 70:34:46 | 45 | 00:41:02 | 30:46:10 | 286 | 00:05:49 | 27:44:06 | 130 | 00:02:09 | 04:38:41 | 966 | 00:02:08 | 34:17:30
M | 153:10:33 |  |  |  |  | 617 | 00:02:15 | [NAME] | 4 | 00:00:36 | 00:02:25 | 14041 | 00:00:33 | 130:03:50 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
N | 04:58:18 |  |  |  |  | 66 | 00:02:22 | 02:35:50 | 1 | 00:00:06 | 00:00:06 | 13348 | 00:00:01 | [NAME] | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
O | 178:13:11 |  |  |  |  | 173 | 00:04:08 | 11:54:26 | 0 | 00:00:00 | 00:00:00 | 1209 | 00:03:46 | 76:02:54 | 118 | 00:18:27 | 36:17:11 | 148 | 00:03:35 | 08:49:59 | 83 | 00:01:53 | 02:35:55 | 820 | 00:02:22 | 32:22:11
P | 166:31:58 |  |  |  |  | 348 | 00:04:21 | 25:15:18 | 0 | 00:00:00 | 00:00:00 | 1156 | [NAME] | 63:38:50 | 280 | 00:10:28 | 48:48:42 | 156 | 00:04:36 | 11:58:40 | 151 | 00:02:35 | 06:28:56 | 644 | 00:02:15 | 24:08:53
Q | 164:00:20 |  |  |  |  | 196 | 00:04:01 | 13:08:49 | 0 | 00:00:00 | 00:00:00 | 1121 | 00:03:55 | 73:04:38 | 25 | 01:01:47 | 25:44:38 | 239 | 00:03:35 | 14:18:17 | 128 | [NAME] | 03:49:26 | 654 | 00:02:35 | 28:11:17
R | 169:32:00 |  |  |  |  | 348 | 00:04:10 | 24:09:15 | 0 | 00:00:00 | 00:02:20 | 751 | [NAME] | 79:03:53 | 112 | 00:18:36 | 34:42:17 | 163 | 00:07:02 | 19:06:32 | 61 | 00:02:22 | 02:24:31 | 378 | 00:03:47 | 23:47:19
S | 170:00:24 |  |  |  |  | 100 | 00:04:20 | 07:13:01 | 0 | 00:00:00 | 00:00:00 | 883 | 00:03:55 | 57:44:04 | 43 | 00:42:19 | 30:19:57 | 124 | [NAME] | 08:16:40 | 47 | 00:02:33 | 02:00:08 | 600 | 00:02:49 | [NAME]
T | 151:28:07 |  |  |  |  | 208 | [NAME] | 06:55:47 | 0 | 00:00:00 | 00:00:00 | 888 | 00:03:46 | 55:40:34 | 21 | 00:50:08 | 17:32:51 | 236 | [NAME] | 14:34:31 | 63 | 00:01:36 | 01:40:59 | 397 | 00:02:45 | 18:12:31
U | 180:42:56 |  |  |  |  | 201 | 00:08:12 | 27:28:34 | 0 | 00:00:00 | 00:00:00 | 911 | 00:03:51 | 58:30:46 | 62 | 00:27:43 | 28:38:02 | 78 | 00:10:05 | [NAME] | 134 | 00:03:23 | 07:32:24 | 611 | [NAME] | 33:43:44
V | 173:01:25 |  |  |  |  | 95 | 00:04:37 | 07:18:27 | 0 | 00:00:00 | 00:00:00 | 816 | 00:05:25 | 73:37:40 | 27 | 01:08:08 | 30:39:30 | 211 | 00:06:26 | 22:36:12 | 65 | 00:02:08 | 02:18:42 | 543 | 00:02:53 | 26:02:32
W | 14:06:51 |  |  |  |  | 159 | 00:03:10 | 08:23:09 | 1 | 00:00:48 | 00:00:48 | 41812 | 00:00:00 | 05:43:42 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
X | 58:09:44 |  |  |  |  | 509 | 00:04:13 | 35:45:10 | 1 | 00:00:49 | 00:00:49 | 219 | 00:06:08 | 22:24:34 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
Y | 192:47:37 |  |  |  |  | 190 | 00:03:11 | 10:05:14 | 0 | 00:00:00 | 00:00:00 | 2898 | 00:01:12 | 57:42:00 | 136 | 00:14:15 | 32:17:50 | 249 | 00:02:17 | 09:26:41 | 176 | 00:01:02 | 03:03:18 | 2194 | 00:01:17 | 46:51:31
Z | 169:28:18 |  |  |  |  | 204 | 00:02:33 | 08:41:05 | 0 | 00:00:00 | 00:00:00 | 1456 | 00:02:57 | 71:41:14 | 24 | 01:08:38 | 27:27:13 | 245 | 00:02:56 | 11:59:48 | 74 | 00:01:45 | 02:09:19 | 990 | 00:01:52 | [NAME]
AA | 47:35:10 |  |  |  |  | 691 | 00:02:11 | 25:09:09 | 1 | 00:00:47 | 00:00:47 | 28225 | 00:00:03 | 22:26:01 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
AB | 08:48:27 |  |  |  |  | 201 | 00:01:39 | 05:31:15 | 1 | 00:00:17 | 00:00:17 | 83 | 00:02:23 | 03:17:12 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
AC | 181:03:31 |  |  |  |  | 142 | 00:04:12 | 09:57:29 | 0 | 00:00:00 | 00:00:00 | 984 | 00:02:59 | 48:53:11 | 160 | 00:15:09 | 40:23:03 | 227 | 00:03:44 | 14:08:08 | 117 | 00:01:34 | 03:04:05 | 607 | 00:01:53 | 19:01:53
AD | 04:23:05 |  |  |  |  | 45 | 00:02:22 | 01:46:38 | 0 | 00:00:00 | 00:00:00 | 42006 | 00:00:00 | 02:36:27 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
AE | 164:23:13 |  |  |  |  | 130 | 00:06:57 | 15:02:39 | 0 | 00:00:00 | 00:00:00 | 1124 | 00:04:42 | 87:58:46 | 18 | 01:12:16 | 21:40:42 | 70 | [NAME] | 06:30:18 | 75 | [NAME] | 04:00:05 | 883 | 00:03:02 | 44:42:35
AF | 171:42:18 |  |  |  |  | 162 | 00:03:17 | 8:50:33 | 0 | 00:00:00 | 00:00:00 | 828 | 00:05:40 | 78:15:04 | 26 | 01:03:49 | 27:39:26 | 162 | 00:05:39 | 15:16:24 | 41 | 00:02:45 | 01:53:01 | 540 | 00:02:54 | 26:04:04
AG | 291:55:28 |  |  |  |  | 198 | 00:05:41 | 18:46:51 | 1 | [NAME] | [NAME] | 1032 | 00:09:45 | 167:35:19 | 28 | 00:51:41 | 24:06:55 | 196 | 00:06:16 | 20:27:40 | 51 | 00:03:16 | [NAME] | 587 | 00:03:16 | 31:53:54
AH | 159:15:01 |  |  |  |  | 199 | 00:07:34 | 1 day, 1:04:09 | 0 | 00:00:00 | 00:00:00 | 743 | 00:04:25 | 54:44:09 | 25 | 01:03:26 | 26:25:43 | 165 | 00:06:51 | 18:49:47 | 80 | 00:04:09 | 05:31:47 | 365 | 00:02:56 | 17:47:52
AI | 167:24:06 |  |  |  |  | 295 | 00:03:14 | 15:53:45 | 1 | [NAME] | [NAME] | 729 | 00:07:21 | 89:13:37 | 53 | 00:24:14 | 21:24:15 | 44 | [NAME] | 02:40:14 | 39 | 00:02:39 | 01:43:36 | 384 | 00:02:46 | 17:44:00
AJ | 165:59:05 |  |  |  |  | 143 | [NAME] | 06:47:25 | 0 | 00:00:00 | 00:00:00 | 987 | 00:02:14 | 36:37:03 | 118 | 00:17:11 | 33:47:30 | 268 | 00:03:28 | 15:27:46 | 50 | 00:01:46 | 01:28:41 | 592 | 00:02:08 | 20:58:40
AK | [NAME] |  |  |  |  | 69 | 00:03:05 | 03:32:30 | 0 | 00:00:00 | 00:00:00 | 37 | 00:05:07 | 03:09:08 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00 | 0 | 00:00:00 | 00:00:00
Summary | 4762:31:58 |  |  |  |  | 7660 | [NAME] | 472:52:08 | 16 | 00:00:52 | 00:13:49 | 205213 | 00:00:34 | 1964:18:17 | 1768 | 00:30:04 | 885:46:36 | 4331 | 00:04:43 | 340:12:28 | 2165 | 00:02:11 | 79:03:31 | 17203 | 00:02:23 | 685:13:43