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

Full Name | 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
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
Agent 1 | 14:00:00 | 23:00:00 | 13:59:00 | 23:00:00 | 14:00:00 | 23:00:00 | MC | MC | 14:00:00 | 23:00:00 | 14:00:00 | 23:00:00 | 14:00:00 | 23:00:00 | 14:03:00 | 23:16:00 | RD | RD | RD | RD | 14:00:00 | 23:00:00 | 14:02:00 | 23:00:00 | 14:00:00 | 23:00:00 | 13:57:00 | 23:02:00
 | 2020-06-08 00:00:00 |  |  |  | 2020-06-09 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
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | PH | PH | PH | PH | 14:00:00 | 23:00:00 | 13:58:00 | 23:00:00 | 09:00:00 | 09:02:13 | 13:59:00 | 23:00:00 | 14:00:00 | 23:00:00 | 13:58:00 | 23:00:00 | RD | RD | RD | RD | 14:00:00 | 23:00:00 | 13:57:00 | 23:00:00 | 14:00:00 | 23:00:00 | 13:52:00 | 23: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
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 14:00:00 | 23:00:00 | 13:58:00 | 23:00:00 | 14:00:00 | 23:00:00 | 13:58:00 | 23:05:00 | RD | RD | RD | RD | 14:00:00 | 23:00:00 | 13:52:00 | 23:00:00 | 14:00:00 | 23:00:00 | 13:55:00 | 23:00:00 | 14:00:00 | 23:00:00 | 14:06:00 | 23:02:00 | 14:00:00 | 23:00:00 | 13:42:00 | 23: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
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 14:00:00 | 23:00:00 | 13:47:00 | 23:00:00 | 14:00:00 | 23:00:00 | 13:49:00 | 23:00:00 | RD | RD | RD | RD | 14:00:00 | 23:00:00 | 13:53:00 | 23:03:00 | 14:00:00 | 23:00:00 | 13:55:00 | 23:00:00 | 14:00:00 | 23:00:00 | MC | MC | 14:00:00 | 23:00:00 | 13:56:00 | 23:00:00
 | 2020-06-29 00:00:00 |  |  |  | 2020-06-30 00:00:00
 | Monday |  |  |  | Tuesday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 14:00:00 | 23:00:00 | 13:58:00 | 23:13:00 | 14:00:00 | 23:00:00 | 13:49:00 | 23:03:00
 | Total Days AM Shift
 | Total Days PM Shift