Spreadsheet: 786477d1657207308-payroll-formulas-needed-for-hours-pto-and-per-diem-payroll-data-report
Sheet: Per Diem

Employee | Date | Did you have per diem yesterday? | Did you have any reimbursable expenses yesterday? | Employee Notes | Submitted | Device | Account
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:41:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:32:00 | iPhone 11 | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 06:30:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:22:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 07:01:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:51:00 | iPhone 11 | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 06:28:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:01:00 | iPhone XÊ€ | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 06:05:00 | iPhone XÊ€ | [NAME]
[NAME] | Mon Jun 20 | Yes (Flagged) | No |  | 2022-06-20 06:04:00 | iPhone14,3 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:14:00 | iPhone 8 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:48:00 | iPhone 8 | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 07:06:00 | iPhone 8 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-28 07:03:00 | iPhone 8 | [NAME]
[NAME] | Wed Jun 29 | Yes (Flagged) | No |  | 2022-06-29 06:31:00 | iPhone 8 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-30 06:33:00 | iPhone 8 | [NAME]
[NAME] | Fri Jul 01 | Yes (Flagged) | No |  | 2022-07-01 06:39:00 | iPhone 8 | [NAME]
Justice Hitomi | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 06:30:00 | Pixel 6 Pro | Justice Hitomi
[NAME] | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 06:50:00 | iPhone XÊ€ | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-30 07:00:00 | iPhone XÊ€ | [NAME]
[NAME] | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 06:55:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 06:29:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:29:00 | iPhone 11 | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 06:31:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-28 06:48:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 29 | Yes (Flagged) | No |  | 2022-06-29 06:01:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-30 06:19:00 | iPhone 11 | [NAME]
[NAME] | Fri Jul 01 | Yes (Flagged) | No |  | 2022-07-01 06:01:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:00:00 | [NAME] | [NAME]
Phat Nguyen | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 06:50:00 | iPhone XÊ€ | [NAME]
Phat Nguyen | [NAME] | Yes (Flagged) | No |  | 2022-06-30 06:59:00 | iPhone XÊ€ | [NAME]
Ricardo Greene II | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:17:00 | iPhone 11 | Ricardo Greene II
[NAME] | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 06:49:00 | iPhone XÊ€ | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-30 06:57:00 | iPhone XÊ€ | [NAME]
[NAME] | Mon Jun 20 | Yes (Flagged) | No |  | 2022-06-20 06:25:00 | [NAME] | [NAME]
[NAME] | Mon Jun 27 | No | Yes (Flagged) | [how much? Upload photo] $30 diesel for man lift | 2022-06-27 07:49:00 | [NAME] | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:01:00 | iPhone XÊ€ | [NAME]
[NAME] | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 09:01:00 | iPhone13,4 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:18:00 | iPhone13,4 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 06:51:00 | Nokia G10 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 20:00:00 | Nokia G10 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-23 09:26:00 | iPhone14,5 | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 06:44:00 | iPhone14,5 | [NAME]
[NAME] | [NAME] 21 | Yes (Flagged) | No |  | 2022-06-21 06:59:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 06:56:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | Yes (Flagged) | [how much? Upload photo] 27.03 | 2022-06-23 06:31:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | Yes (Flagged) | [how much? Upload photo] 27.03 | 2022-06-23 06:31:00 | iPhone 11 | [NAME]
[NAME] | [NAME] 24 | Yes (Flagged) | No |  | 2022-06-24 06:30:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-28 07:25:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 29 | Yes (Flagged) | No |  | 2022-06-29 06:33:00 | iPhone 11 | [NAME]
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-06-30 06:45:00 | iPhone 11 | [NAME]
[NAME] | Fri Jul 01 | Yes (Flagged) | No |  | 2022-07-01 06:05:00 | iPhone 11 | [NAME]
[NAME] | Wed Jun 22 | Yes (Flagged) | No |  | 2022-06-22 07:00:00 | iPhone13,4 | [NAME]