Spreadsheet: 271157d1381848589-need-help-with-overlapping-times-ticket-times
Sheet: Sheet1

Ticket # | Date in | Time In | Time Out | Total Minutes
20212146 | 2013-09-03 00:00:00 | 00:22:09 | 09:07:17 | 525 | 13
20212148 | 2013-09-03 00:00:00 | 04:47:13 | 12:51:17 | 484 | 13
20212149 | 2013-09-03 00:00:00 | 04:56:22 | 16:21:09 | 685 | 8
20212150 | 2013-09-03 00:00:00 | 04:57:40 | 15:56:39 | 659 | 8
20212151 | 2013-09-03 00:00:00 | 05:10:15 | 16:21:56 | 671 | 8
20212152 | 2013-09-03 00:00:00 | 05:20:55 | 16:21:18 | 661 | 8
20212153 | 2013-09-03 00:00:00 | 05:25:56 | 13:23:04 | 478 | 8
20212154 | 2013-09-03 00:00:00 | 05:27:48 | 14:27:05 | 540 | 8
20212155 | 2013-09-03 00:00:00 | 05:28:16 | 14:22:28 | 534 | 8
20212157 | 2013-09-03 00:00:00 | 05:32:41 | 15:21:48 | 589 | 8
20212158 | 2013-09-03 00:00:00 | 05:33:43 | [NAME] | 532 | 8
20212159 | 2013-09-03 00:00:00 | 05:34:21 | 16:22:23 | 648 | 8
20212160 | 2013-09-03 00:00:00 | 05:35:55 | 14:55:30 | 560 | 8
20212161 | 2013-09-03 00:00:00 | 05:36:23 | 14:09:55 | 513 | 8
20212162 | 2013-09-03 00:00:00 | 05:36:56 | 14:25:03 | 529 | 8
20212163 | 2013-09-03 00:00:00 | 05:37:33 | 15:09:27 | 572 | 8
20212165 | 2013-09-03 00:00:00 | 05:41:44 | 14:48:26 | 547 | 8
20212166 | 2013-09-03 00:00:00 | 05:42:17 | 14:10:02 | 508 | 8
20212167 | 2013-09-03 00:00:00 | [NAME] | 14:54:32 | 551 | 8
20212168 | 2013-09-03 00:00:00 | 05:43:51 | 14:26:24 | 523 | 8
20212169 | 2013-09-03 00:00:00 | 05:46:20 | 14:35:15 | 529 | 8
20212170 | 2013-09-03 00:00:00 | 05:47:08 | 16:26:51 | 639 | 8
20212171 | 2013-09-03 00:00:00 | 05:47:18 | 13:45:20 | 478 | 8
20212172 | 2013-09-03 00:00:00 | 05:47:32 | 16:22:39 | 635 | 8
20212174 | 2013-09-03 00:00:00 | 05:53:02 | 15:26:47 | 573 | 8
10008172 | 2013-09-03 00:00:00 | 05:53:11 | 14:55:05 | 542 | 8
20212175 | 2013-09-03 00:00:00 | [NAME] | 16:39:42 | 645 | 8
20212176 | 2013-09-03 00:00:00 | 05:55:36 | 16:31:08 | 636 | 8
20212177 | 2013-09-03 00:00:00 | 05:55:50 | 14:35:47 | 520 | 8
20212178 | 2013-09-03 00:00:00 | 05:56:45 | 14:18:34 | 502 | 8
20212179 | 2013-09-03 00:00:00 | 06:00:02 | 09:37:57 | 217 | 8
20212180 | 2013-09-03 00:00:00 | [NAME] | 13:43:17 | 463 | 8
20212181 | 2013-09-03 00:00:00 | 06:01:04 | 13:40:01 | 459 | 8
20212182 | 2013-09-03 00:00:00 | 06:02:51 | 15:17:27 | 555 | 8
20212184 | 2013-09-03 00:00:00 | 06:05:59 | 14:17:52 | 492 | 8
20212185 | 2013-09-03 00:00:00 | 06:06:12 | 15:56:08 | 590 | 8
20212186 | 2013-09-03 00:00:00 | [NAME] | 15:11:48 | 544 | 8
20212187 | 2013-09-03 00:00:00 | 06:07:40 | 16:25:06 | 618 | 8
20212188 | 2013-09-03 00:00:00 | 06:10:15 | 14:00:28 | 470 | 8
10008173 | 2013-09-03 00:00:00 | 06:10:21 | 16:23:06 | 613 | 8
20212190 | 2013-09-03 00:00:00 | 06:12:08 | 14:32:12 | 500 | 8
20212191 | 2013-09-03 00:00:00 | 06:12:22 | 14:36:13 | 504 | 8
20212192 | 2013-09-03 00:00:00 | 06:12:46 | 13:43:50 | 451 | 8
20212194 | 2013-09-03 00:00:00 | 06:14:08 | 15:06:00 | 532 | 8
20212195 | 2013-09-03 00:00:00 | 06:14:37 | 14:55:19 | 521 | 8
20212200 | 2013-09-03 00:00:00 | 06:25:33 | [NAME] | 491 | 8
20212202 | 2013-09-03 00:00:00 | 06:28:32 | 15:33:23 | 545 | 8
10008174 | 2013-09-03 00:00:00 | 06:28:49 | 15:13:05 | 525 | 8
20212204 | 2013-09-03 00:00:00 | 06:33:46 | 15:25:12 | 532 | 8
20212205 | 2013-09-03 00:00:00 | 06:35:47 | 14:58:49 | 503 | 8
20212206 | 2013-09-03 00:00:00 | 06:39:34 | 15:15:10 | 516 | 8
10008175 | 2013-09-03 00:00:00 | 06:41:18 | 15:11:26 | 510 | 8
20212209 | 2013-09-03 00:00:00 | 06:41:22 | 14:36:35 | 475 | 8
10008176 | 2013-09-03 00:00:00 | 06:41:30 | 15:11:20 | 510 | 8
20212210 | 2013-09-03 00:00:00 | [NAME] | [NAME] | 539 | 8
20212211 | 2013-09-03 00:00:00 | [NAME] | 15:27:07 | 526 | 8
20212213 | 2013-09-03 00:00:00 | 06:43:18 | 15:50:45 | 547 | 8
20212215 | 2013-09-03 00:00:00 | 06:44:41 | 16:45:45 | 601 | 8
20212216 | 2013-09-03 00:00:00 | 06:44:52 | 14:13:25 | 449 | 8
20212217 | 2013-09-03 00:00:00 | 06:48:00 | 15:27:27 | 519 | 8
10008177 | 2013-09-03 00:00:00 | 06:49:30 | 15:12:51 | 503 | 8
20212223 | 2013-09-03 00:00:00 | 06:52:47 | 15:13:38 | 501 | 8
20212224 | 2013-09-03 00:00:00 | 06:53:51 | 15:06:47 | 493 | 8
20212225 | 2013-09-03 00:00:00 | 06:55:23 | 16:17:13 | 562 | 8
20212227 | 2013-09-03 00:00:00 | 06:56:07 | 15:43:18 | 527 | 8
20212229 | 2013-09-03 00:00:00 | 06:57:03 | 15:30:00 | 513 | 8
20212230 | 2013-09-03 00:00:00 | 06:57:15 | 15:14:06 | 497 | 8
20212231 | 2013-09-03 00:00:00 | 07:00:49 | 14:05:53 | 425 | 8
30086455 | 2013-09-03 00:00:00 | 07:01:07 | 15:10:44 | 489 | 8
20212233 | 2013-09-03 00:00:00 | 07:04:17 | 13:56:00 | 412 | 8
20212239 | 2013-09-03 00:00:00 | [NAME] | 13:40:33 | 388 | 8
20212240 | 2013-09-03 00:00:00 | 07:13:43 | 15:37:15 | 504 | 8
20212252 | 2013-09-03 00:00:00 | 07:25:13 | 15:37:30 | 492 | 8
30086456 | 2013-09-03 00:00:00 | 07:43:16 | [NAME] | 497 | 8
20212271 | 2013-09-03 00:00:00 | 07:45:10 | 16:05:05 | 500 | 8
20212273 | 2013-09-03 00:00:00 | 07:46:46 | 16:05:23 | 499 | 8
20212273 | 2013-09-03 00:00:00 | 07:46:46 | 16:05:23 | 499 | 8
20212277 | 2013-09-03 00:00:00 | 07:48:21 | 17:15:53 | 567 | 8
20212280 | 2013-09-03 00:00:00 | 07:50:30 | 12:21:16 | 271 | 8
20212299 | 2013-09-03 00:00:00 | [NAME] | 14:56:18 | 411 | 8
20212301 | 2013-09-03 00:00:00 | 08:05:26 | 14:21:56 | 376 | 8
20212302 | 2013-09-03 00:00:00 | 08:05:53 | 16:02:59 | 477 | 8
20212307 | 2013-09-03 00:00:00 | 08:08:37 | 18:37:17 | 629 | 8
20212313 | 2013-09-03 00:00:00 | 08:16:33 | 15:27:58 | 431 | 8
10008202 | 2013-09-03 00:00:00 | 08:40:44 | 17:45:09 | 545 | 8
20212352 | 2013-09-03 00:00:00 | 08:58:29 | [NAME] | 56 | 4
10008209 | 2013-09-03 00:00:00 | 09:03:40 | 18:08:20 | 545 | 8
20212363 | 2013-09-03 00:00:00 | 09:18:28 | 14:09:09 | 291 | 13
20212368 | 2013-09-03 00:00:00 | 09:41:09 | 18:11:38 | 510 | 13
20212371 | 2013-09-03 00:00:00 | 09:47:31 | 15:29:28 | 342 | 13
20212381 | 2013-09-03 00:00:00 | 10:23:01 | 10:55:12 | 32 | 4
20212384 | 2013-09-03 00:00:00 | 10:55:53 | 15:33:35 | 278 | 13
20212390 | 2013-09-03 00:00:00 | 11:47:15 | 19:18:08 | 451 | 13
20212409 | 2013-09-03 00:00:00 | 12:35:43 | 15:49:13 | 194 | 13
30086473 | 2013-09-03 00:00:00 | 14:10:30 | 22:31:23 | 501 | 13
20212425 | 2013-09-03 00:00:00 | 14:44:36 | 18:07:12 | 203 | 13
20212429 | 2013-09-03 00:00:00 | 15:14:52 | 22:50:30 | 456 | 13
20212434 | 2013-09-03 00:00:00 | 17:09:42 | 18:51:20 | 102 | 7
20212436 | 2013-09-03 00:00:00 | 18:16:07 | 22:21:01 | 245 | 13
20212142 | 2013-09-02 00:00:00 | 21:33:15 | 02:30:13 | 297 | 13
20212143 | 2013-09-02 00:00:00 | 21:59:07 | 07:01:04 | 542 | 13
20212144 | 2013-09-02 00:00:00 | 22:13:06 | 07:15:41 | 542 | 13