Spreadsheet: 238059d1369380332-insert-missing-date-per-employee-time-record
Sheet: Sheet1

TIME RECORD - FEBRUARY 2013
Biometric No. | Name | Date | Time in (am) | Time out (am) | Time in (pm) | Time out (pm) | Clock In 3 | Total Working Hours | Undertime
131 | Employee A | 2/4/2013
131 | Employee A | 2/5/2013 | 7:03:00 AM | 12:14:00 PM | 12:15:00 PM | 4:33:00 PM |  | 07:33:00 | 00:27:00
131 | Employee A | 2/6/2013 | 7:37:00 AM | 12:35:00 PM | 12:35:00 PM | 4:35:00 PM |  | 07:35:00 | 00:25:00
131 | Employee A | 2/7/2013 | 7:15:00 AM | 12:28:00 PM | 12:29:00 PM | 4:34:00 PM |  | 07:34:00 | 00:26:00
131 | Employee A | 2/8/2013 | 7:01:00 AM | 12:47:00 PM | 12:47:00 PM | 3:00:00 PM |  | 06:00:00 | 02:00:00
131 | Employee A | 2/11/2013 | 6:12:00 AM | 12:23:00 PM | 12:24:00 PM | 4:35:00 PM |  | 07:35:00 | 00:25:00
131 | Employee A | 2/12/2013 | 7:10:00 AM | 12:34:00 PM | 12:34:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
131 | Employee A | 2/14/2013 | 7:29:00 AM | 12:22:00 PM | 12:22:00 PM | 4:34:00 PM |  | 07:34:00 | 00:26:00
131 | Employee A | 2/15/2013 | 6:58:00 AM | 12:37:00 PM | 12:37:00 PM | 4:24:00 PM |  | 07:24:00 | 00:36:00
131 | Employee A | 2/18/2013 | 6:19:00 AM | 12:44:00 PM | 12:44:00 PM | 4:31:00 PM |  | 07:31:00 | 00:29:00
131 | Employee A | 2/19/2013 | 7:14:00 AM | 12:38:00 PM | 12:38:00 PM | 4:31:00 PM |  | 07:31:00 | 00:29:00
131 | Employee A | 2/20/2013 | 7:09:00 AM | 12:25:00 PM | 12:25:00 PM | 4:10:00 PM |  | 07:10:00 | 00:50:00
131 | Employee A | 2/21/2013 | 7:08:00 AM | 12:34:00 PM | 12:34:00 PM | 4:29:00 PM |  | 07:29:00 | 00:31:00
131 | Employee A | 2/22/2013 | 7:05:00 AM | 12:28:00 PM |  |  |  | 04:00:00 | 04:00:00
131 | Employee A | 2/25/2013 | 6:20:00 AM | 12:28:00 PM | 12:28:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
131 | Employee A | 2/26/2013 | 7:05:00 AM | 12:20:00 PM | 12:20:00 PM | 4:32:00 PM |  | 07:32:00 | 00:28:00
131 | Employee A | 2/27/2013 | 6:58:00 AM | 12:35:00 PM | 12:36:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
131 | Employee A | 2/28/2013 | 7:20:00 AM | 12:29:00 PM |  |  |  | 04:00:00 | 04:00:00
132 | Employee B | 2/19/2013 | 9:17:00 AM | 12:02:00 PM |  |  |  | 02:43:00 | 05:17:00
132 | Employee B | 2/26/2013 | 9:33:00 AM | 12:19:00 PM | 12:19:00 PM | 1:50:00 PM |  | 03:17:00 | 04:43:00
132 | Employee B | 2/28/2013 | 9:37:00 AM | 12:52:00 PM | 12:52:00 PM | 3:04:00 PM |  | 04:27:00 | 03:33:00
133 | Employee C | 2/4/2013
133 | Employee C | 2/5/2013 | 7:51:00 AM | 12:05:00 PM | 12:05:00 PM | 4:48:00 PM |  | 07:48:00 | 00:12:00
133 | Employee C | 2/6/2013 | 7:59:00 AM | 12:05:00 PM | 12:05:00 PM | 4:45:00 PM |  | 07:45:00 | 00:15:00
133 | Employee C | 2/7/2013 | 7:46:00 AM | 12:08:00 PM | 12:09:00 PM | 4:45:00 PM |  | 07:45:00 | 00:15:00
133 | Employee C | 2/8/2013 | 7:38:00 AM | 12:00:00 PM | 12:00:00 PM | 4:36:00 PM |  | 07:36:00 | 00:24:00
133 | Employee C | 2/11/2013 | 7:36:00 AM | 12:05:00 PM | 12:05:00 PM | 4:42:00 PM |  | 07:42:00 | 00:18:00
133 | Employee C | 2/12/2013 | 7:31:00 AM | 12:04:00 PM | 12:04:00 PM | 4:44:00 PM |  | 07:44:00 | 00:16:00
133 | Employee C | 2/13/2013 | 7:47:00 AM | 12:06:00 PM | 12:06:00 PM | 4:43:00 PM |  | 07:43:00 | 00:17:00
133 | Employee C | 2/14/2013 | 7:35:00 AM | 12:06:00 PM | 12:06:00 PM |  |  | 04:00:00 | 04:00:00
133 | Employee C | 2/15/2013 | 7:34:00 AM | 12:07:00 PM | 12:07:00 PM | 4:43:00 PM |  | 07:43:00 | 00:17:00
133 | Employee C | 2/18/2013 | 7:47:00 AM | 12:08:00 PM | 12:08:00 PM | 4:43:00 PM |  | 07:43:00 | 00:17:00
133 | Employee C | 2/19/2013 | 7:31:00 AM | 12:13:00 PM | 12:13:00 PM | 4:41:00 PM |  | 07:41:00 | 00:19:00
133 | Employee C | 2/20/2013 | 7:25:00 AM | 12:09:00 PM | 12:09:00 PM | 4:23:00 PM |  | 07:23:00 | 00:37:00
133 | Employee C | 2/21/2013 | 7:26:00 AM | 12:12:00 PM | 12:12:00 PM |  |  | 04:00:00 | 04:00:00
133 | Employee C | 2/22/2013 | 7:26:00 AM | 12:13:00 PM | 12:13:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
133 | Employee C | 2/25/2013 | 7:42:00 AM | 12:11:00 PM | 12:11:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
133 | Employee C | 2/26/2013 | 7:22:00 AM | 12:09:00 PM | 12:09:00 PM | 4:39:00 PM |  | 07:39:00 | 00:21:00
133 | Employee C | 2/27/2013 | 7:45:00 AM | 12:18:00 PM | 12:18:00 PM |  |  | 04:00:00 | 04:00:00
133 | Employee C | 2/28/2013 | 7:24:00 AM | 12:07:00 PM | 12:07:00 PM | 4:42:00 PM |  | 07:42:00 | 00:18:00
134 | Employee D | 2/7/2013 | 12:09:00 PM
134 | Employee D | 2/14/2013 | 8:39:00 AM
134 | Employee D | 2/21/2013 | 9:04:00 AM
134 | Employee D | 2/28/2013 | 10:39:00 AM
11 | Employee E | 2/7/2013 | 8:33:00 AM | 12:27:00 PM | 12:27:00 PM | 4:34:00 PM |  | 07:01:00 | 00:59:00
11 | Employee E | 2013-02-08 00:00:00 | with locator slip
11 | Employee E | 2/11/2013 | 9:31:00 AM | 12:20:00 PM | 12:20:00 PM | 4:28:00 PM |  | 05:57:00 | 02:03:00
11 | Employee E | 2013-02-12 00:00:00
11 | Employee E | 2013-02-13 00:00:00
11 | Employee E | 2/14/2013 | 12:05:00 PM |  |  | 4:44:00 PM |  | 03:44:00 | 04:16:00
11 | Employee E | 2/15/2013 | 8:43:00 AM | 12:19:00 PM | 12:19:00 PM | 4:53:00 PM |  | 07:10:00 | 00:50:00
11 | Employee E | 2/18/2013 | 7:57:00 AM | 12:07:00 PM | 12:07:00 PM | 4:44:00 PM |  | 07:44:00 | 00:16:00
11 | Employee E | 2/19/2013 | 8:21:00 AM | 12:00:00 PM | 12:01:00 PM |  |  | 03:39:00 | 04:21:00
11 | Employee E | 2/20/2013 | 8:14:00 AM | 12:13:00 PM | 12:13:00 PM | 4:52:00 PM |  | 07:38:00 | 00:22:00
11 | Employee E | 2013-02-21 00:00:00
11 | Employee E | 2/22/2013 | 8:53:00 AM | 12:17:00 PM | 12:17:00 PM | 5:02:00 PM |  | 07:07:00 | 00:53:00
11 | Employee E | 2/25/2013 | 8:32:00 AM | 12:06:00 PM | 12:07:00 PM | 4:52:00 PM |  | 07:20:00 | 00:40:00
11 | Employee E | 2/26/2013 | 8:38:00 AM | 12:05:00 PM | 12:05:00 PM |  |  | 03:22:00 | 04:38:00
11 | Employee E | 2/27/2013 | 8:34:00 AM | 12:34:00 PM | 12:34:00 PM |  |  | 03:26:00 | 04:34:00
11 | Employee E | 2/28/2013 | 8:23:00 AM | 12:27:00 PM | 12:28:00 PM | 4:45:00 PM |  | 07:22:00 | 00:38:00
Expected output?
131 | Employee A | 2013-02-01 00:00:00
131 | Employee A | 2/4/2013
131 | Employee A | 2/5/2013 | 7:03:00 AM | 12:14:00 PM | 12:15:00 PM | 4:33:00 PM |  | 07:33:00 | 00:27:00
131 | Employee A | 2/6/2013 | 7:37:00 AM | 12:35:00 PM | 12:35:00 PM | 4:35:00 PM |  | 07:35:00 | 00:25:00
131 | Employee A | 2/7/2013 | 7:15:00 AM | 12:28:00 PM | 12:29:00 PM | 4:34:00 PM |  | 07:34:00 | 00:26:00
131 | Employee A | 2/8/2013 | 7:01:00 AM | 12:47:00 PM | 12:47:00 PM | 3:00:00 PM |  | 06:00:00 | 02:00:00
131 | Employee A | 2/11/2013 | 6:12:00 AM | 12:23:00 PM | 12:24:00 PM | 4:35:00 PM |  | 07:35:00 | 00:25:00
131 | Employee A | 2/12/2013 | 7:10:00 AM | 12:34:00 PM | 12:34:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
131 | Employee A | 2013-02-13 00:00:00
131 | Employee A | 2/14/2013 | 7:29:00 AM | 12:22:00 PM | 12:22:00 PM | 4:34:00 PM |  | 07:34:00 | 00:26:00
131 | Employee A | 2/15/2013 | 6:58:00 AM | 12:37:00 PM | 12:37:00 PM | 4:24:00 PM |  | 07:24:00 | 00:36:00
131 | Employee A | 2/18/2013 | 6:19:00 AM | 12:44:00 PM | 12:44:00 PM | 4:31:00 PM |  | 07:31:00 | 00:29:00
131 | Employee A | 2/19/2013 | 7:14:00 AM | 12:38:00 PM | 12:38:00 PM | 4:31:00 PM |  | 07:31:00 | 00:29:00
131 | Employee A | 2/20/2013 | 7:09:00 AM | 12:25:00 PM | 12:25:00 PM | 4:10:00 PM |  | 07:10:00 | 00:50:00
131 | Employee A | 2/21/2013 | 7:08:00 AM | 12:34:00 PM | 12:34:00 PM | 4:29:00 PM |  | 07:29:00 | 00:31:00
131 | Employee A | 2/22/2013 | 7:05:00 AM | 12:28:00 PM |  |  |  | 04:00:00 | 04:00:00
131 | Employee A | 2/25/2013 | 6:20:00 AM | 12:28:00 PM | 12:28:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
131 | Employee A | 2/26/2013 | 7:05:00 AM | 12:20:00 PM | 12:20:00 PM | 4:32:00 PM |  | 07:32:00 | 00:28:00
131 | Employee A | 2/27/2013 | 6:58:00 AM | 12:35:00 PM | 12:36:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
131 | Employee A | 2/28/2013 | 7:20:00 AM | 12:29:00 PM |  |  |  | 04:00:00 | 04:00:00
132 | Employee B | 2013-02-01 00:00:00
132 | Employee B | 2013-02-04 00:00:00
132 | Employee B | 2013-02-05 00:00:00
132 | Employee B | 2013-02-06 00:00:00
132 | Employee B | 2013-02-07 00:00:00
132 | Employee B | 2013-02-08 00:00:00
132 | Employee B | 2013-02-11 00:00:00
132 | Employee B | 2013-02-12 00:00:00
132 | Employee B | 2013-02-13 00:00:00
132 | Employee B | 2013-02-14 00:00:00
132 | Employee B | 2013-02-15 00:00:00
132 | Employee B | 2013-02-18 00:00:00
132 | Employee B | 2/19/2013 | 9:17:00 AM | 12:02:00 PM |  |  |  | 02:43:00 | 05:17:00
132 | Employee B | 2013-02-20 00:00:00
132 | Employee B | 2013-02-21 00:00:00
132 | Employee B | 2013-02-22 00:00:00
132 | Employee B | 2013-02-25 00:00:00
132 | Employee B | 2/26/2013 | 9:33:00 AM | 12:19:00 PM | 12:19:00 PM | 1:50:00 PM |  | 03:17:00 | 04:43:00
132 | Employee B | 2013-02-27 00:00:00
132 | Employee B | 2/28/2013 | 9:37:00 AM | 12:52:00 PM | 12:52:00 PM | 3:04:00 PM |  | 04:27:00 | 03:33:00
133 | Employee C | 2013-02-01 00:00:00
133 | Employee C | 2/4/2013
133 | Employee C | 2/5/2013 | 7:51:00 AM | 12:05:00 PM | 12:05:00 PM | 4:48:00 PM |  | 07:48:00 | 00:12:00
133 | Employee C | 2/6/2013 | 7:59:00 AM | 12:05:00 PM | 12:05:00 PM | 4:45:00 PM |  | 07:45:00 | 00:15:00
133 | Employee C | 2/7/2013 | 7:46:00 AM | 12:08:00 PM | 12:09:00 PM | 4:45:00 PM |  | 07:45:00 | 00:15:00
133 | Employee C | 2/8/2013 | 7:38:00 AM | 12:00:00 PM | 12:00:00 PM | 4:36:00 PM |  | 07:36:00 | 00:24:00
133 | Employee C | 2/11/2013 | 7:36:00 AM | 12:05:00 PM | 12:05:00 PM | 4:42:00 PM |  | 07:42:00 | 00:18:00
133 | Employee C | 2/12/2013 | 7:31:00 AM | 12:04:00 PM | 12:04:00 PM | 4:44:00 PM |  | 07:44:00 | 00:16:00
133 | Employee C | 2/13/2013 | 7:47:00 AM | 12:06:00 PM | 12:06:00 PM | 4:43:00 PM |  | 07:43:00 | 00:17:00
133 | Employee C | 2/14/2013 | 7:35:00 AM | 12:06:00 PM | 12:06:00 PM |  |  | 04:00:00 | 04:00:00
133 | Employee C | 2/15/2013 | 7:34:00 AM | 12:07:00 PM | 12:07:00 PM | 4:43:00 PM |  | 07:43:00 | 00:17:00
133 | Employee C | 2/18/2013 | 7:47:00 AM | 12:08:00 PM | 12:08:00 PM | 4:43:00 PM |  | 07:43:00 | 00:17:00
133 | Employee C | 2/19/2013 | 7:31:00 AM | 12:13:00 PM | 12:13:00 PM | 4:41:00 PM |  | 07:41:00 | 00:19:00
133 | Employee C | 2/20/2013 | 7:25:00 AM | 12:09:00 PM | 12:09:00 PM | 4:23:00 PM |  | 07:23:00 | 00:37:00
133 | Employee C | 2/21/2013 | 7:26:00 AM | 12:12:00 PM | 12:12:00 PM |  |  | 04:00:00 | 04:00:00
133 | Employee C | 2/22/2013 | 7:26:00 AM | 12:13:00 PM | 12:13:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
133 | Employee C | 2/25/2013 | 7:42:00 AM | 12:11:00 PM | 12:11:00 PM | 4:40:00 PM |  | 07:40:00 | 00:20:00
133 | Employee C | 2/26/2013 | 7:22:00 AM | 12:09:00 PM | 12:09:00 PM | 4:39:00 PM |  | 07:39:00 | 00:21:00
133 | Employee C | 2/27/2013 | 7:45:00 AM | 12:18:00 PM | 12:18:00 PM |  |  | 04:00:00 | 04:00:00
133 | Employee C | 2/28/2013 | 7:24:00 AM | 12:07:00 PM | 12:07:00 PM | 4:42:00 PM |  | 07:42:00 | 00:18:00
134 | Employee D | 2013-02-01 00:00:00
134 | Employee D | 2013-02-04 00:00:00
134 | Employee D | 2013-02-05 00:00:00
134 | Employee D | 2013-02-06 00:00:00
134 | Employee D | 2/7/2013 | 12:09:00 PM
134 | Employee D | 2013-02-08 00:00:00
134 | Employee D | 2013-02-11 00:00:00
134 | Employee D | 2013-02-12 00:00:00
134 | Employee D | 2013-02-13 00:00:00
134 | Employee D | 2/14/2013 | 8:39:00 AM
134 | Employee D | 2013-02-15 00:00:00
134 | Employee D | 2013-02-18 00:00:00
134 | Employee D | 2/19/2013
134 | Employee D | 2013-02-20 00:00:00
134 | Employee D | 2/21/2013 | 9:04:00 AM
134 | Employee D | 2013-02-22 00:00:00
134 | Employee D | 2013-02-25 00:00:00
134 | Employee D | 2/26/2013
134 | Employee D | 2013-02-27 00:00:00
134 | Employee D | 2/28/2013 | 10:39:00 AM
134 | Employee E | 2013-02-01 00:00:00
134 | Employee E | 2013-02-04 00:00:00
134 | Employee E | 2013-02-05 00:00:00
134 | Employee E | 2013-02-06 00:00:00
11 | Employee E | 2/7/2013 | 8:33:00 AM | 12:27:00 PM | 12:27:00 PM | 4:34:00 PM |  | 07:01:00 | 00:59:00
11 | Employee E | 2013-02-08 00:00:00 | with locator slip
11 | Employee E | 2/11/2013 | 9:31:00 AM | 12:20:00 PM | 12:20:00 PM | 4:28:00 PM |  | 05:57:00 | 02:03:00
11 | Employee E | 2013-02-12 00:00:00
11 | Employee E | 2013-02-13 00:00:00
11 | Employee E | 2/14/2013 | 12:05:00 PM |  |  | 4:44:00 PM |  | 03:44:00 | 04:16:00
11 | Employee E | 2/15/2013 | 8:43:00 AM | 12:19:00 PM | 12:19:00 PM | 4:53:00 PM |  | 07:10:00 | 00:50:00
11 | Employee E | 2/18/2013 | 7:57:00 AM | 12:07:00 PM | 12:07:00 PM | 4:44:00 PM |  | 07:44:00 | 00:16:00
11 | Employee E | 2/19/2013 | 8:21:00 AM | 12:00:00 PM | 12:01:00 PM |  |  | 03:39:00 | 04:21:00
11 | Employee E | 2/20/2013 | 8:14:00 AM | 12:13:00 PM | 12:13:00 PM | 4:52:00 PM |  | 07:38:00 | 00:22:00
11 | Employee E | 2013-02-21 00:00:00
11 | Employee E | 2/22/2013 | 8:53:00 AM | 12:17:00 PM | 12:17:00 PM | 5:02:00 PM |  | 07:07:00 | 00:53:00
11 | Employee E | 2/25/2013 | 8:32:00 AM | 12:06:00 PM | 12:07:00 PM | 4:52:00 PM |  | 07:20:00 | 00:40:00
11 | Employee E | 2/26/2013 | 8:38:00 AM | 12:05:00 PM | 12:05:00 PM |  |  | 03:22:00 | 04:38:00
11 | Employee E | 2/27/2013 | 8:34:00 AM | 12:34:00 PM | 12:34:00 PM |  |  | 03:26:00 | 04:34:00
11 | Employee E | 2/28/2013 | 8:23:00 AM | 12:27:00 PM | 12:28:00 PM | 4:45:00 PM |  | 07:22:00 | 00:38:00