Spreadsheet: 888673d1739249368-looking-to-find-some-formula-method-etc-to-clean-up-adp-timecard-sheets-sample-adp-workbook-for-ggcalc-1-
Sheet: Table1

Last Name | First Name | Date Worked | Time In-Out | Pay Code
Ultimor | Tobias | 12/19/2021 | 11:30 AM - 04:10 PM
Ultimor | Tobias | 12/20/2021 | 09:05 AM - 06:06 PM
Ultimor | Tobias | 12/21/2021 | 09:07 AM - 04:31 PM
Ultimor | Tobias | 12/22/2021 | 10:13 AM - 04:49 PM
Ultimor | Tobias | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Ultimor | Tobias | 12/27/2021 | 08:00 AM - 04:00 PM | PTO
Ultimor | Tobias | 12/28/2021 | 08:00 AM - 04:00 PM | PTO
Ultimor | Tobias | 12/29/2021 | 08:00 AM - 04:00 PM | PTO
Ultimor | Tobias | 12/30/2021 | 08:00 AM - 04:00 PM | PTO
Ultimor | Tobias | 12/31/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Ultimor | Tobias | 01/01/2022 | 10:01 AM - 06:19 PM
Landon | Roland | 12/19/2021 | 10:50 AM - 05:18 PM
Landon | Roland | 12/20/2021 | 10:31 AM - 06:15 PM
Landon | Roland | 12/21/2021 | 10:28 AM - 06:04 PM
Landon | Roland | 12/22/2021 | 10:33 AM - 06:17 PM
Landon | Roland | 12/23/2021 | 11:46 AM - 06:17 PM
Landon | Roland | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Landon | Roland | 12/29/2021 | 10:35 AM - 06:25 PM
Landon | Roland | 12/30/2021 | 10:33 AM - 06:25 PM
Landon | Roland | 12/31/2021 | 10:30 AM - 05:01 PM
Landon | Roland | 01/01/2022 | 08:00 AM - 04:00 PM | HOLIDAY
Ducote | [NAME] | 12/19/2021 | 01:09 PM - 04:01 PM
Ducote | [NAME] | 12/20/2021 | 09:38 AM - 05:47 PM
Ducote | [NAME] | 12/22/2021 | 09:18 AM - 05:28 PM
Ducote | [NAME] | 12/23/2021 | 09:25 AM - 05:35 PM
Ducote | [NAME] | 12/24/2021 | 09:24 AM - 05:02 PM
Ducote | [NAME] | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Ducote | [NAME] | 12/27/2021 | 10:01 AM - 05:00 PM
Ducote | [NAME] | 12/28/2021 | 09:59 AM - 05:41 PM
Ducote | [NAME] | 12/29/2021 | 08:00 AM - 04:00 PM | PTO
Ducote | [NAME] | 12/30/2021 | 08:00 AM - 04:00 PM | PTO
Ducote | [NAME] | 01/01/2022 | 08:00 AM - 04:00 PM | HOLIDAY
Inist | [NAME] | 12/21/2021 | 09:05 AM - 01:00 PM
Inist | [NAME] | 12/21/2021 | 01:30 PM - 05:45 PM
Inist | [NAME] | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Inist | [NAME] | 12/27/2021 | 09:14 AM - 02:23 PM
Inist | [NAME] | 12/27/2021 | 03:03 PM - 06:35 PM
Inist | [NAME] | 12/28/2021 | 09:36 AM - 01:49 PM
Inist | [NAME] | 12/28/2021 | 02:33 PM - 07:50 PM
Inist | [NAME] | 12/29/2021 | 09:39 AM - 02:30 PM
Inist | [NAME] | 12/29/2021 | 03:25 PM - 06:31 PM
Inist | [NAME] | 12/30/2021 | 09:13 AM - 04:34 PM
Inist | [NAME] | 12/30/2021 | 04:45 PM - 06:38 PM
Inist | [NAME] | 12/31/2021 | 09:40 AM - 02:25 PM
Inist | [NAME] | 12/31/2021 | 02:56 PM - 07:02 PM
Inist | [NAME] | 01/01/2022 | 08:00 AM - 04:00 PM | HOLIDAY
[NAME] | [NAME] | 12/21/2021 | 11:05 AM - 05:51 PM
[NAME] | [NAME] | 12/31/2021 | 10:36 AM - 04:03 PM
[NAME] | [NAME] | 01/01/2022 | 11:06 AM - 05:00 PM
Sackett | [NAME] | 12/20/2021 | 11:00 AM - 07:00 PM
Sackett | [NAME] | 12/21/2021 | 09:00 AM - 06:56 PM
Sackett | [NAME] | 12/23/2021 | 10:00 AM - 06:30 PM
Sackett | [NAME] | 12/24/2021 | 10:00 AM - 04:00 PM
Sackett | [NAME] | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Sackett | [NAME] | 12/28/2021 | 12:00 PM - 06:45 PM
Sackett | [NAME] | 12/29/2021 | 08:00 AM - 04:00 PM | PTO
Sackett | [NAME] | 12/30/2021 | 08:00 AM - 04:00 PM | PTO
Sackett | [NAME] | 12/31/2021 | 08:00 AM - 04:00 PM | PTO
Sackett | [NAME] | 01/01/2022 | 08:00 AM - 04:00 PM | HOLIDAY
Miriel | Hathrenair | 12/19/2021 | 10:40 AM - 05:40 PM
Miriel | Hathrenair | 12/22/2021 | 09:35 AM - 03:54 PM
Miriel | Hathrenair | 12/22/2021 | 04:35 PM - 06:15 PM
Miriel | Hathrenair | 12/23/2021 | 09:30 AM - 02:30 PM
Miriel | Hathrenair | 12/23/2021 | 03:00 PM - 06:30 PM
Miriel | Hathrenair | 12/24/2021 | 09:30 AM - 04:00 PM
Miriel | Hathrenair | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Miriel | Hathrenair | 12/27/2021 | 09:30 AM - 03:00 PM
Miriel | Hathrenair | 12/27/2021 | 03:30 PM - 06:25 PM
Miriel | Hathrenair | 12/28/2021 | 09:30 AM - 03:00 PM
Miriel | Hathrenair | 12/28/2021 | 03:30 PM - 06:45 PM
Miriel | Hathrenair | 12/29/2021 | 10:00 AM - 03:00 PM
Miriel | Hathrenair | 12/30/2021 | 09:35 AM - 03:00 PM
Miriel | Hathrenair | 12/30/2021 | 03:30 PM - 06:15 PM
Miriel | Hathrenair | 12/31/2021 | 09:30 AM - 05:00 PM
Dig | Kagen | 12/29/2021 | 01:15 PM - 05:32 PM
Shereg | Mim | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Shereg | Mim | 01/01/2022 | 08:00 AM - 04:00 PM | HOLIDAY
Hazebane | Dezour | 12/21/2021 | 09:00 AM - 05:06 PM
Hazebane | Dezour | 12/22/2021 | 08:57 AM - 05:02 PM
Hazebane | Dezour | 12/23/2021 | 08:54 AM - 05:00 PM
Hazebane | Dezour | 12/24/2021 | 08:59 AM - 03:57 PM
Hazebane | Dezour | 12/25/2021 | 08:00 AM - 04:00 PM | HOLIDAY
Hazebane | Dezour | 12/28/2021 | 09:28 AM - 05:38 PM
Hazebane | Dezour | 12/29/2021 | 09:28 AM - 05:27 PM
Hazebane | Dezour | 12/30/2021 | 09:28 AM - 05:25 PM
Hazebane | Dezour | 12/31/2021 | 09:30 AM - 04:30 PM
Hazebane | Dezour | 01/01/2022 | 08:00 AM - 04:00 PM | HOLIDAY
Ironhide | [NAME] | 12/20/2021 | 01:30 PM - 05:23 PM
Ironhide | [NAME] | 12/21/2021 | 01:02 PM - 05:06 PM
Ironhide | [NAME] | 12/23/2021 | 09:01 AM - 02:28 PM
Ironhide | [NAME] | 12/26/2021 | 11:16 AM - 04:05 PM
Ironhide | [NAME] | 12/27/2021 | 10:08 AM - 05:17 PM
Ironhide | [NAME] | 12/28/2021 | 09:59 AM - 05:02 PM
Ironhide | [NAME] | 12/31/2021 | 10:00 AM - 03:10 PM
[NAME] | Gelvyn | 12/21/2021 | 09:01 AM - 02:19 PM
[NAME] | Gelvyn | 12/22/2021 | 09:03 AM - 05:13 PM
[NAME] | Gelvyn | 12/30/2021 | 01:00 PM - 05:18 PM