Spreadsheet: 478150d1472655653-excel-problem-identifying-the-correct-login-and-logout-of-an-employee-based-on-range-sample
Sheet: Dump

User ID | Name | Type | Date | Start | Finish | Auto Logout | MCH Auto Logout | Duration | Break | Reason | Convert1 | Convert2
10117 | Agent7 | Login | 2016-08-30 00:00:00 | 08:56:18 | 08:58:08 |  |  | 00:01:50 | 00:00:00
10117 | Agent7 | Break | 2016-08-30 00:00:00 | 08:56:49 | 08:57:02 | 1 |  | 00:00:00 | 00:00:13 | Break-AutoLogout
10117 | Agent7 | Login | 2016-08-30 00:00:00 | 09:02:10 | 11:26:41 |  |  | 02:24:31 | 00:00:00
10117 | Agent7 | Worktime | 2016-08-30 00:00:00 | 10:33:26 | 11:04:09 |  |  | 00:00:00 | 00:00:00
10117 | Agent7 | Break | 2016-08-30 00:00:00 | 11:11:22 | 11:26:37 |  |  | 00:00:00 | 00:15:15 | B1- First Break
10117 | Agent7 | Login | 2016-08-30 00:00:00 | 11:34:21 | 16:29:18 |  |  | 04:54:57 | 00:00:00
10117 | Agent7 | Break | 2016-08-30 00:00:00 | 13:26:32 | 13:55:28 |  |  | 00:00:00 | 00:28:56 | L - Lunch
10117 | Agent7 | Break | 2016-08-30 00:00:00 | 15:46:10 | 16:21:14 |  |  | 00:00:00 | 00:35:04 | L - Lunch
10117 | Agent7 | Break | 2016-08-30 00:00:00 | 16:21:14 | 16:29:18 |  |  | 00:00:00 | 00:08:04
10117 | Agent7 | Login | 2016-08-30 00:00:00 | 16:31:17 | 16:45:42 |  |  | 00:14:25 | 00:00:00
10117 | Agent7 | Login | 2016-08-30 00:00:00 | 16:45:44 | 17:57:09 |  |  | 01:11:25 | 00:00:00
10117 | Agent7 | Break | 2016-08-30 00:00:00 | 17:25:39 | 17:27:36 |  |  | 00:00:00 | 00:01:57 | P - Personal Time
10337 | Agent3 | Login | 2016-08-30 00:00:00 | 00:00:00 | 03:58:37 |  |  | 03:58:37 | 00:00:00
10337 | Agent3 | Worktime | 2016-08-30 00:00:00 | 00:00:00 | 02:00:18 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | Row Labels | Min of Start | [NAME] of Finish | Min of Field1 | Sum of Field2
10337 | Agent3 | Break | 2016-08-30 00:00:00 | 02:00:18 | 02:15:25 |  |  | 00:00:00 | 00:15:07 | B2 - Second Break |  |  |  | Agent3 | 00:00:00 | 23:59:59 | 1900-01-05 11:14:46 | 1900-01-06 05:16:11
10337 | Agent3 | Worktime | 2016-08-30 00:00:00 | 02:15:25 | 03:58:33 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | Grand Total | 00:00:00 | 23:59:59 | 1900-01-05 11:14:46 | 1900-01-06 05:16:11
10337 | Agent3 | Login | 2016-08-30 00:00:00 | 18:57:49 | 23:59:59 |  |  | 05:02:10 | 00:00:00
10337 | Agent3 | Worktime | 2016-08-30 00:00:00 | 18:57:54 | 21:00:19 |  |  | 00:00:00 | 00:00:00
10337 | Agent3 | Break | 2016-08-30 00:00:00 | 21:00:19 | 21:10:50 |  |  | 00:00:00 | 00:10:31 | B1- First Break
10337 | Agent3 | Worktime | 2016-08-30 00:00:00 | 21:10:50 | 22:59:58 |  |  | 00:00:00 | 00:00:00
10337 | Agent3 | Break | 2016-08-30 00:00:00 | 22:59:58 | 23:52:13 |  |  | 00:00:00 | 00:52:15 | L - Lunch
10337 | Agent3 | Worktime | 2016-08-30 00:00:00 | 23:52:13 | 23:59:59 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Login | 2016-08-30 00:00:00 | 00:00:00 | 03:58:36 |  |  | 03:58:36 | 00:00:00
10338 | Agent6 | Worktime | 2016-08-30 00:00:00 | 00:00:00 | 02:16:14 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Break | 2016-08-30 00:00:00 | 02:16:14 | 02:21:28 |  |  | 00:00:00 | 00:05:14 | B2 - Second Break
10338 | Agent6 | Worktime | 2016-08-30 00:00:00 | 02:21:28 | 03:58:36 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Login | 2016-08-30 00:00:00 | 18:43:25 | 23:59:59 |  |  | 05:16:34 | 00:00:00
10338 | Agent6 | Worktime | 2016-08-30 00:00:00 | 18:43:39 | 21:22:21 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Break | 2016-08-30 00:00:00 | 21:22:21 | 21:26:14 |  |  | 00:00:00 | 00:03:53 | B1- First Break
10338 | Agent6 | Worktime | 2016-08-30 00:00:00 | 21:26:14 | 21:48:38 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Break | 2016-08-30 00:00:00 | 21:48:38 | 21:49:12 |  |  | 00:00:00 | 00:00:34
10338 | Agent6 | Worktime | 2016-08-30 00:00:00 | 21:49:12 | 22:10:03 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Break | 2016-08-30 00:00:00 | 22:10:03 | 22:12:08 |  |  | 00:00:00 | 00:02:05
10338 | Agent6 | Worktime | 2016-08-30 00:00:00 | 22:12:08 | 23:12:35 |  |  | 00:00:00 | 00:00:00
10338 | Agent6 | Break | 2016-08-30 00:00:00 | 23:12:35 | 23:59:59 |  |  | 00:00:00 | 00:47:24 | L - Lunch
10398 | Agent8 | Login | 2016-08-30 00:00:00 | 00:00:00 | 03:59:32 |  |  | 03:59:32 | 00:00:00
10398 | Agent8 | Worktime | 2016-08-30 00:00:00 | 00:00:00 | 01:58:45 |  |  | 00:00:00 | 00:00:00
10398 | Agent8 | Break | 2016-08-30 00:00:00 | 01:58:45 | 02:12:59 |  |  | 00:00:00 | 00:14:14 | B2 - Second Break
10398 | Agent8 | Worktime | 2016-08-30 00:00:00 | 02:12:59 | 03:59:32 |  |  | 00:00:00 | 00:00:00
10398 | Agent8 | Login | 2016-08-30 00:00:00 | 18:13:29 | 23:59:59 |  |  | 05:46:30 | 00:00:00
10398 | Agent8 | Worktime | 2016-08-30 00:00:00 | 18:13:35 | 20:58:11 |  |  | 00:00:00 | 00:00:00
10398 | Agent8 | Break | 2016-08-30 00:00:00 | 20:58:11 | 21:12:45 |  |  | 00:00:00 | 00:14:34 | B1- First Break
10398 | Agent8 | Worktime | 2016-08-30 00:00:00 | 21:12:45 | 22:59:22 |  |  | 00:00:00 | 00:00:00
10398 | Agent8 | Break | 2016-08-30 00:00:00 | 22:59:22 | 23:54:16 |  |  | 00:00:00 | 00:54:54 | L - Lunch
10398 | Agent8 | Worktime | 2016-08-30 00:00:00 | 23:54:16 | 23:59:59 |  |  | 00:00:00 | 00:00:00
10399 | Agent1 | Login | 2016-08-30 00:00:00 | 08:26:07 | 10:53:41 |  |  | 02:27:34 | 00:00:00
10399 | Agent1 | Break | 2016-08-30 00:00:00 | 10:16:56 | 10:31:53 |  |  | 00:00:00 | 00:14:57 | B1- First Break
10399 | Agent1 | Break | 2016-08-30 00:00:00 | 10:53:19 | 10:53:41 | 1 |  | 00:00:00 | 00:00:22 | Break-AutoLogout
10399 | Agent1 | Login | 2016-08-30 00:00:00 | 10:54:36 | 17:26:02 |  |  | 06:31:26 | 00:00:00
10399 | Agent1 | Break | 2016-08-30 00:00:00 | 12:03:12 | 13:02:57 |  |  | 00:00:00 | 00:59:45 | L - Lunch
10399 | Agent1 | Worktime | 2016-08-30 00:00:00 | 13:29:42 | 14:32:13 |  |  | 00:00:00 | 00:00:00
10399 | Agent1 | Break | 2016-08-30 00:00:00 | 15:08:58 | 15:23:55 |  |  | 00:00:00 | 00:14:57 | B2 - Second Break
10410 | Agent9 | Login | 2016-08-30 00:00:00 | 07:55:57 | 08:59:31 |  |  | 01:03:34 | 00:00:00
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 08:31:34 | 08:37:55 |  |  | 00:00:00 | 00:06:21 | P - Personal Time
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 08:56:49 | 08:59:25 |  |  | 00:00:00 | 00:02:36 | P - Personal Time
10410 | Agent9 | Login | 2016-08-30 00:00:00 | 08:59:33 | 17:08:49 |  |  | 08:09:16 | 00:00:00
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 10:17:07 | 10:31:40 |  |  | 00:00:00 | 00:14:33 | B1- First Break
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 12:21:40 | 12:35:58 |  |  | 00:00:00 | 00:14:18 | B2 - Second Break
10410 | Agent9 | Worktime | 2016-08-30 00:00:00 | 12:58:20 | 13:16:33 |  |  | 00:00:00 | 00:00:00
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 14:00:20 | 14:04:48 |  |  | 00:00:00 | 00:04:28 | P - Personal Time
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 14:13:24 | 15:13:00 |  |  | 00:00:00 | 00:59:36 | L - Lunch
10410 | Agent9 | Break | 2016-08-30 00:00:00 | 16:10:52 | 16:15:06 |  |  | 00:00:00 | 00:04:14 | P - Personal Time
10410 | Agent9 | Worktime | 2016-08-30 00:00:00 | 16:26:01 | 17:08:49 |  |  | 00:00:00 | 00:00:00
10492 | Agent4 | Login | 2016-08-30 00:00:00 | 17:47:18 | 23:59:59 |  |  | 06:12:41 | 00:00:00
10492 | Agent4 | Worktime | 2016-08-30 00:00:00 | 17:49:36 | 19:57:26 |  |  | 00:00:00 | 00:00:00
10492 | Agent4 | Break | 2016-08-30 00:00:00 | 19:57:26 | 20:05:48 |  |  | 00:00:00 | 00:08:22 | B1- First Break
10492 | Agent4 | Worktime | 2016-08-30 00:00:00 | 20:05:48 | 22:35:57 |  |  | 00:00:00 | 00:00:00
10492 | Agent4 | Break | 2016-08-30 00:00:00 | 22:35:57 | 23:12:46 |  |  | 00:00:00 | 00:36:49 | L - Lunch
10492 | Agent4 | Worktime | 2016-08-30 00:00:00 | 23:12:46 | 23:59:59 |  |  | 00:00:00 | 00:00:00
10545 | Agent10 | Login | 2016-08-30 00:00:00 | 00:00:00 | 04:00:18 |  |  | 04:00:18 | 00:00:00
10545 | Agent10 | Worktime | 2016-08-30 00:00:00 | 00:00:00 | 02:01:38 |  |  | 00:00:00 | 00:00:00
10545 | Agent10 | Break | 2016-08-30 00:00:00 | 02:01:38 | 02:15:59 |  |  | 00:00:00 | 00:14:21 | B2 - Second Break
10545 | Agent10 | Worktime | 2016-08-30 00:00:00 | 02:15:59 | 04:00:12 |  |  | 00:00:00 | 00:00:00
10545 | Agent10 | Login | 2016-08-30 00:00:00 | 18:44:55 | 23:59:59 |  |  | 05:15:04 | 00:00:00
10545 | Agent10 | Worktime | 2016-08-30 00:00:00 | 18:45:05 | 21:01:43 |  |  | 00:00:00 | 00:00:00
10545 | Agent10 | Break | 2016-08-30 00:00:00 | 21:01:43 | 21:13:10 |  |  | 00:00:00 | 00:11:27 | B1- First Break
10545 | Agent10 | Worktime | 2016-08-30 00:00:00 | 21:13:10 | 21:46:59 |  |  | 00:00:00 | 00:00:00
10545 | Agent10 | Break | 2016-08-30 00:00:00 | 21:46:59 | 21:47:14 |  |  | 00:00:00 | 00:00:15
10545 | Agent10 | Worktime | 2016-08-30 00:00:00 | 21:47:14 | 23:01:39 |  |  | 00:00:00 | 00:00:00
10545 | Agent10 | Break | 2016-08-30 00:00:00 | 23:01:39 | 23:56:47 |  |  | 00:00:00 | 00:55:08 | L - Lunch
10545 | Agent10 | Worktime | 2016-08-30 00:00:00 | 23:56:47 | 23:59:59 |  |  | 00:00:00 | 00:00:00
10650 | Agent2 | Login | 2016-08-30 00:00:00 | 12:56:55 | 14:24:31 |  |  | 01:27:36 | 00:00:00
10650 | Agent2 | Login | 2016-08-30 00:00:00 | 14:24:34 | 19:46:33 |  |  | 05:21:59 | 00:00:00
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 15:01:06 | 16:01:20 |  |  | 00:00:00 | 01:00:14 | L - Lunch
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 17:33:18 | 17:38:05 |  |  | 00:00:00 | 00:04:47 | P - Personal Time
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 18:03:26 | 18:19:47 |  |  | 00:00:00 | 00:16:21 | B1- First Break
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 19:13:34 | 19:20:10 |  |  | 00:00:00 | 00:06:36 | P - Personal Time
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 19:39:36 | 19:42:40 | 1 |  | 00:00:00 | 00:03:04 | Break-AutoLogout
10650 | Agent2 | Login | 2016-08-30 00:00:00 | 19:46:35 | 21:58:44 |  |  | 02:12:09 | 00:00:00
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 20:04:41 | 20:19:53 |  |  | 00:00:00 | 00:15:12 | B2 - Second Break
10650 | Agent2 | Break | 2016-08-30 00:00:00 | 21:32:49 | 21:45:57 | 1 |  | 00:00:00 | 00:13:08 | Break-AutoLogout
10752 | Agent5 | Login | 2016-08-30 00:00:00 | 00:00:00 | 23:59:59 |  |  | 23:59:59 | 00:00:00
10752 | Agent5 | Login | 2016-08-30 00:00:00 | 02:12:08 | 06:57:16 |  |  | 04:45:08 | 00:00:00
10752 | Agent5 | Break | 2016-08-30 00:00:00 | 03:31:44 | 04:28:24 |  |  | 00:00:00 | 00:56:40 | L - Lunch
10752 | Agent5 | Worktime | 2016-08-30 00:00:00 | 04:50:01 | 05:02:01 |  |  | 00:00:00 | 00:00:00
10752 | Agent5 | Login | 2016-08-30 00:00:00 | 21:55:02 | 22:19:08 |  |  | 00:24:06 | 00:00:00
10752 | Agent5 | Login | 2016-08-30 00:00:00 | 22:29:24 | 23:59:59 |  |  | 01:30:35 | 00:00:00
10752 | Agent5 | Break | 2016-08-30 00:00:00 | 23:11:33 | 23:26:18 |  |  | 00:00:00 | 00:14:45 | B1- First Break