Spreadsheet: 686282d1594473507-lookup-matchdata-from-another-different-format-table-book1-ricky82-
Sheet: Main

 | 2020-06-01 00:00:00 |  |  |  |  |  |  | 2020-06-02 00:00:00 |  |  |  |  |  |  | 2020-06-03 00:00:00 |  |  |  |  |  |  | 2020-06-04 00:00:00 |  |  |  |  |  |  | 2020-06-05 00:00:00 |  |  |  |  |  |  | 2020-06-06 00:00:00 |  |  |  |  |  |  | 2020-06-07 00:00:00 |  |  |  |  |  |  | 2020-06-08 00:00:00 |  |  |  |  |  |  | 2020-06-09 00:00:00 |  |  |  |  |  |  | 2020-06-10 00:00:00 |  |  |  |  |  |  | 2020-06-11 00:00:00 |  |  |  |  |  |  | 2020-06-12 00:00:00 |  |  |  |  |  |  | 2020-06-13 00:00:00 |  |  |  |  |  |  | 2020-06-14 00:00:00 |  |  |  |  |  |  | 2020-06-15 00:00:00 |  |  |  |  |  |  | 2020-06-16 00:00:00 |  |  |  |  |  |  | 2020-06-17 00:00:00 |  |  |  |  |  |  | 2020-06-18 00:00:00 |  |  |  |  |  |  | 2020-06-19 00:00:00 |  |  |  |  |  |  | 2020-06-20 00:00:00 |  |  |  |  |  |  | 2020-06-21 00:00:00 |  |  |  |  |  |  | 2020-06-22 00:00:00 |  |  |  |  |  |  | 2020-06-23 00:00:00 |  |  |  |  |  |  | 2020-06-24 00:00:00 |  |  |  |  |  |  | 2020-06-25 00:00:00 |  |  |  |  |  |  | 2020-06-26 00:00:00 |  |  |  |  |  |  | 2020-06-27 00:00:00 |  |  |  |  |  |  | 2020-06-28 00:00:00 |  |  |  |  |  |  | 2020-06-29 00:00:00 |  |  |  |  |  |  | 2020-06-30 00:00:00
Full Name | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Lateness hh:[NAME]:ss | AM | PM
Agent 1 | 14:00:00 | 23:00:00 | 13:59:00 | 23:00:00 | 09:00:00 | 09:01:12 |  | 14:00:00 | 23:00:00 | MC | MC |  |  |  | 14:00:00 | 23:00:00 | 14:00:00 | 23:00:00 | 09:00:00 | 09:00:23 | 00:00:23 | 14:00:00 | 23:00:00 | 14:03:00 | 23:16:00 | 09:00:00 | 09:13:04 | 00:03:26 | RD | RD | RD | RD |  |  |  | 14:00:00 | 23:00:00 | 14:02:00 | 23:00:00 | 09:00:00 | 08:58:19 | 00:02:00 | 14:00:00 | 23:00:00 | 13:57:00 | 23:02:00 | 09:00:00 | 09:04:25 |  | PH | PH | PH | PH |  |  |  | 14:00:00 | 23:00:00 | 13:58:00 | 23:00:00 | 09:00:00 | 09:02:13 |  | 14:00:00 | 23:00:00 | 13:59:00 | 23:00:00 | 09:00:00 | 09:00:27 |  | 14:00:00 | 23:00:00 | 13:58:00 | 23:00:00 | 09:00:00 | 09:01:12 |  | RD | RD | RD | RD |  |  |  | 14:00:00 | 23:00:00 | 13:57:00 | 23:00:00 | 09:00:00 | 09:02:34 |  | 14:00:00 | 23:00:00 | 13:52:00 | 23:00:00 | 09:00:00 | 09:07:35 |  | 14:00:00 | 23:00:00 | 13:58:00 | 23:00:00 | 09:00:00 | 09:01:39 |  | 14:00:00 | 23:00:00 | 13:58:00 | 23:05:00 | 09:00:00 | 09:07:10 |  | RD | RD | RD | RD |  |  |  | 14:00:00 | 23:00:00 | 13:52:00 | 23:00:00 | 09:00:00 | 09:07:49 |  | 14:00:00 | 23:00:00 | 13:55:00 | 23:00:00 | 09:00:00 | 09:04:40 |  | 14:00:00 | 23:00:00 | 14:06:00 | 23:02:00 | 09:00:00 | 08:55:47 | 00:06:58 | 14:00:00 | 23:00:00 | 13:42:00 | 23:00:00 | 09:00:00 | 09:17:24 |  | 14:00:00 | 23:00:00 | 13:47:00 | 23:00:00 | 09:00:00 | 09:13:36 |  | 14:00:00 | 23:00:00 | 13:49:00 | 23:00:00 | 09:00:00 | 09:11:11 |  | RD | RD | RD | RD |  |  |  | 14:00:00 | 23:00:00 | 13:53:00 | 23:03:00 | 09:00:00 | 09:09:54 |  | 14:00:00 | 23:00:00 | 13:55:00 | 23:00:00 | 09:00:00 | 09:05:02 |  | 14:00:00 | 23:00:00 | MC | MC |  |  |  | 14:00:00 | 23:00:00 | 13:56:00 | 23:00:00 | 09:00:00 | 09:03:23 |  | 14:00:00 | 23:00:00 | 13:58:00 | 23:13:00 | 09:00:00 | 09:14:44 |  | 14:00:00 | 23:00:00 | 13:49:00 | 23:03:00 | 09:00:00 | 09:14:13
Agent 2 | 14:00:00 | 23:00:00 | 13:14:00 | 23:08:00 | 09:00:00 | 09:53:36 |  | 14:00:00 | 23:00:00 | 12:50:00 | 23:38:00 | 09:00:00 | 10:47:20 |  | 14:00:00 | 23:00:00 | 13:24:00 | 23:02:00 | 09:00:00 | 09:37:40 |  | 14:00:00 | 23:00:00 | 12:02:00 | 23:06:00 | 09:00:00 | 11:03:26 |  | 14:00:00 | 23:00:00 | 13:09:00 | 23:04:00 | 09:00:00 | 09:54:54 |  | RD | RD | RD | RD |  |  |  | RL | RL | RL | RL |  |  |  | 10:00:00 | 19:00:00 | 09:29:00 | 19:04:00 | 09:00:00 | 09:35:06 |  | 10:00:00 | 19:00:00 | 09:42:00 | 19:05:00 | 09:00:00 | 09:22:44 |  | 10:00:00 | 19:00:00 | 09:42:00 | 19:04:00 | 09:00:00 | 09:22:09 |  | 10:00:00 | 19:00:00 | 09:30:00 | 19:02:00 | 09:00:00 | 09:31:47 |  | 10:00:00 | 19:00:00 | 09:32:00 | 19:00:00 | 09:00:00 | 09:27:23 |  | 10:00:00 | 19:00:00 | 09:49:00 | 19:00:00 | 09:00:00 | 09:10:48 |  | RD | RD | RD | RD |  |  |  | 10:00:00 | 19:00:00 | MC | MC |  |  |  | 10:00:00 | 19:00:00 | 08:40:00 | 19:04:00 | 09:00:00 | 10:24:19 |  | 10:00:00 | 19:00:00 | 09:30:00 | 19:00:00 | 09:00:00 | 09:29:23 |  | 10:00:00 | 19:00:00 | 09:30:00 | 19:15:00 | 09:00:00 | 09:44:46 |  | 10:00:00 | 19:00:00 | 09:35:00 | 19:00:00 | 09:00:00 | 09:24:12 |  | 10:00:00 | 19:00:00 | 09:33:00 | 19:00:00 | 09:00:00 | 09:26:26 |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:28:00 | 17:10:00 | 09:00:00 | 09:42:05 |  | 08:00:00 | 17:00:00 | 07:33:00 | 17:07:00 | 09:00:00 | 09:33:59 |  | 08:00:00 | 17:00:00 | 07:28:00 | 17:01:00 | 09:00:00 | 09:33:32 |  | 08:00:00 | 17:00:00 | 07:23:00 | 17:00:00 | 09:00:00 | 09:36:52 |  | RL | RL | RL | RL |  |  |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:23:00 | 17:28:00 | 09:00:00 | 10:04:23 |  | 08:00:00 | 17:00:00 | 07:15:00 | 17:00:00 | 09:00:00 | 09:44:10 |  | 08:00:00 | 17:00:00 | 07:31:00 | 17:02:00 | 09:00:00 | 09:30:27
Agent 3 | 08:00:00 | 17:00:00 | 07:47:00 | 17:05:00 | 09:00:00 | 09:17:23 |  | 08:00:00 | 17:00:00 | MC | MC |  |  |  | 08:00:00 | 17:00:00 | 07:51:00 | 17:04:00 | 09:00:00 | 09:12:57 |  | 08:00:00 | 17:00:00 | 07:35:00 | 17:01:00 | 09:00:00 | 09:26:08 |  | RL | RL | RL | RL |  |  |  | 08:00:00 | 17:00:00 | 07:36:00 | 17:00:00 | 09:00:00 | 09:23:46 |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:51:00 | 17:00:00 | 09:00:00 | 09:09:31 |  | 08:00:00 | 17:00:00 | 07:46:00 | 17:00:00 | 09:00:00 | 09:14:12 |  | 08:00:00 | 17:00:00 | 07:42:00 | 17:04:00 | 09:00:00 | 09:21:51 |  | 08:00:00 | 17:00:00 | 07:42:00 | 17:02:00 | 09:00:00 | 09:20:13 |  | 08:00:00 | 17:00:00 | 07:50:00 | 17:00:00 | 09:00:00 | 09:10:19 |  | 08:00:00 | 17:00:00 | 07:51:00 | 17:00:00 | 09:00:00 | 09:09:23 |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:56:00 | 17:03:00 | 09:00:00 | 09:07:10 |  | 08:00:00 | 17:00:00 | 07:51:00 | 17:00:00 | 09:00:00 | 09:09:24 |  | 08:00:00 | 17:00:00 | MC | MC |  |  |  | 08:00:00 | 17:00:00 | 07:39:00 | 17:02:00 | 09:00:00 | 09:23:16 |  | 08:00:00 | 17:00:00 | 07:44:00 | 17:03:00 | 09:00:00 | 09:19:25 |  | 08:00:00 | 17:00:00 | 07:57:00 | 17:05:00 | 09:00:00 | 09:07:10 |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:45:00 | 17:02:00 | 09:00:00 | 09:17:23 |  | 08:00:00 | 17:00:00 | 07:38:00 | 17:05:00 | 09:00:00 | 09:26:57 |  | RL | RL | RL | RL |  |  |  | 08:00:00 | 17:00:00 | MC | MC |  |  |  | 08:00:00 | 17:00:00 | MC | MC |  |  |  | 08:00:00 | 17:00:00 | 07:50:00 | 17:02:00 | 09:00:00 | 09:11:47 |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:26:00 | 17:02:00 | 09:00:00 | 09:35:51 |  | 08:00:00 | 17:00:00 | 07:33:00 | 17:07:00 | 09:00:00 | 09:33:33
Agent 4 | 08:00:00 | 17:00:00 | 07:47:00 | 17:06:00 | 09:00:00 | 09:18:44 |  | 08:00:00 | 17:00:00 | 07:40:00 | 18:15:00 | 09:00:00 | 10:34:35 |  | 08:00:00 | 17:00:00 | 07:39:00 | 17:00:00 | 09:00:00 | 09:20:47 |  | 08:00:00 | 17:00:00 | 07:37:00 | 17:12:00 | 09:00:00 | 09:35:20 |  | 08:00:00 | 17:00:00 | 07:35:00 | 17:03:00 | 09:00:00 | 09:28:01 |  | RD | RD | RD | RD |  |  |  | 08:00:00 | 17:00:00 | 07:31:00 | 17:10:00 | 09:00:00 | 09:39:29 |  | 14:00:00 | 23:00:00 | 13:30:00 | 23:00:00 | 09:00:00 | 09:30:03 |  | 14:00:00 | 23:00:00 | 13:20:00 | 23:00:00 | 09:00:00 | 09:39:52 |  | 14:00:00 | 23:00:00 | 13:26:00 | 23:00:00 | 09:00:00 | 09:34:10 |  | 14:00:00 | 23:00:00 | 13:22:00 | 23:00:00 | 09:00:00 | 09:37:05 |  | 14:00:00 | 23:00:00 | 13:22:00 | 23:00:00 | 09:00:00 | 09:37:22 |  | RD | RD | RD | RD |  |  |  | 14:00:00 | 23:00:00 | 13:15:00 | 23:00:00 | 09:00:00 | 09:44:28 |  | 14:00:00 | 23:00:00 | 13:20:00 | 23:02:00 | 09:00:00 | 09:42:44 |  | 14:00:00 | 23:00:00 | 13:16:00 | 23:00:00 | 09:00:00 | 09:43:56 |  | 14:00:00 | 23:00:00 | 13:19:00 | 23:00:00 | 09:00:00 | 09:41:00 |  | RD | RD | RD | RD |  |  |  | 14:00:00 | 23:00:00 | 13:18:00 | 23:00:00 | 09:00:00 | 09:41:30 |  | 14:00:00 | 23:00:00 | 13:16:00 | 23:00:00 | 09:00:00 | 09:43:26 |  | 08:00:00 | 17:00:00 | 07:39:00 | 17:01:00 | 09:00:00 | 09:22:33 |  | 08:00:00 | 17:00:00 | 07:36:00 | 17:28:00 | 09:00:00 | 09:51:32 |  | 08:00:00 | 17:00:00 | 07:33:00 | 18:32:00 | 09:00:00 | 10:59:07 |  | 08:00:00 | 17:00:00 | 07:35:00 | 17:04:00 | 09:00:00 | 09:29:16 |  | 08:00:00 | 17:00:00 | 07:39:00 | 17:07:00 | 09:00:00 | 09:28:07 |  | 08:00:00 | 17:00:00 | 07:33:00 | 17:00:00 | 09:00:00 | 09:27:00 |  | RD | RD | RD | RD |  |  |  | RL | RL | RL | RL |  |  |  | RL | RL | RL | RL |  |  |  | RD | RD | RD | RD