Spreadsheet: 868080d1714773387-calculated-pivot-field-lunch-help
Sheet: Data

# | Name | Department | Date | Time | Hours | PayCode | [NAME] | [NAME] | Short Lunch
100 | Doe, [NAME] | Billing | 2024-04-01 00:00:00 | 06:15:00 | 1.4 | REG PAY | 1.4 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-10 00:00:00 | 11:33:00 | 0.5 | OT PAY | 0.5 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-10 00:00:00 | 11:33:00 | 2.25 | REG PAY | 2.25 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-10 00:00:00 | 05:48:00 | 0.38 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-10 00:00:00 | 05:48:00 | 5.37 | REG PAY | 5.37 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-11 00:00:00 | 12:16:00 | 0.37 | OT PAY | 0.37 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-11 00:00:00 | 12:16:00 | 1.66 | REG PAY | 1.66 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-11 00:00:00 | 05:56:00 | 0.34 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-11 00:00:00 | 05:56:00 | 6 | REG PAY | 6 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-12 00:00:00 | 05:48:00 | 2.18 | REG PAY | 2.18 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-12 00:00:00 | 05:48:00 | 6.32 | OT PAY | 6.32 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-15 00:00:00 | 11:57:00 | 0.13 | OT PAY | 0.13 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-15 00:00:00 | 11:57:00 | 2.22 | REG PAY | 2.22 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-15 00:00:00 | 05:42:00 | 0.47 | LUNCH NP | 0 | 1 | 0
100 | Doe, [NAME] | Billing | 2024-04-15 00:00:00 | 05:42:00 | 5.78 | REG PAY | 5.78 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-16 00:00:00 | 11:59:00 | 0.3 | OT PAY | 0.3 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-16 00:00:00 | 11:59:00 | 2.1 | REG PAY | 2.1 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-16 00:00:00 | 06:05:00 | 0.43 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-16 00:00:00 | 06:05:00 | 5.47 | REG PAY | 5.47 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-17 00:00:00 | 05:53:00 | 5.78 | REG PAY | 5.78 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-02 00:00:00 | 05:50:00 | 0.57 | OT PAY | 0.57 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-02 00:00:00 | 05:50:00 | 8 | REG PAY | 8 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-03 00:00:00 | 10:55:00 | 0.18 | OT PAY | 0.18 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-03 00:00:00 | 10:55:00 | 3.3 | REG PAY | 3.3 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-03 00:00:00 | 06:13:00 | 0.35 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-03 00:00:00 | 06:13:00 | 4.35 | REG PAY | 4.35 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-04 00:00:00 | 11:05:00 | 0.13 | OT PAY | 0.13 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-04 00:00:00 | 11:05:00 | 3.07 | REG PAY | 3.07 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-04 00:00:00 | 05:42:00 | 0.45 | LUNCH NP | 0 | 1 | 0
100 | Doe, [NAME] | Billing | 2024-04-04 00:00:00 | 05:42:00 | 4.93 | REG PAY | 4.93 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-05 00:00:00 | 11:04:00 | 0.52 | OT PAY | 0.52 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-05 00:00:00 | 11:04:00 | 2.73 | REG PAY | 2.73 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-05 00:00:00 | 05:48:00 | 0.27 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-05 00:00:00 | 05:48:00 | 5 | REG PAY | 5 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-08 00:00:00 | 11:03:00 | 0.56 | OT PAY | 0.56 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-08 00:00:00 | 11:03:00 | 2.67 | REG PAY | 2.67 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-08 00:00:00 | 05:43:00 | 0.38 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-08 00:00:00 | 05:43:00 | 4.95 | REG PAY | 4.95 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-09 00:00:00 | 10:56:00 | 0.35 | OT PAY | 0.35 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-09 00:00:00 | 10:56:00 | 2.89 | REG PAY | 2.89 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-04-09 00:00:00 | 05:49:00 | 0.35 | SHORT LUNCH | 0 | 0 | 1
100 | Doe, [NAME] | Billing | 2024-04-09 00:00:00 | 05:49:00 | 4.76 | REG PAY | 4.76 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-05-01 00:00:00 | 10:56:00 | 0.02 | OT PAY | 0.02 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-05-01 00:00:00 | 10:56:00 | 3.47 | REG PAY | 3.47 | 0 | 0
100 | Doe, [NAME] | Billing | 2024-05-01 00:00:00 | 05:54:00 | 0.5 | LUNCH NP | 0 | 1 | 0
100 | Doe, [NAME] | Billing | 2024-05-01 00:00:00 | 05:54:00 | 4.53 | REG PAY | 4.53 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-10 00:00:00 | 11:43:00 | 3.25 | REG PAY | 3.25 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-10 00:00:00 | 06:28:00 | 0.5 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-10 00:00:00 | 06:28:00 | 4.75 | REG PAY | 4.75 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-11 00:00:00 | 12:38:00 | 1.25 | REG PAY | 1.25 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-11 00:00:00 | 06:24:00 | 0.46 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-11 00:00:00 | 06:24:00 | 5.77 | REG PAY | 5.77 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-12 00:00:00 | 12:35:00 | 2.03 | OT PAY | 2.03 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-12 00:00:00 | 06:22:00 | 0.27 | OT PAY | 0.27 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-12 00:00:00 | 06:22:00 | 0.51 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-12 00:00:00 | 06:22:00 | 5.43 | REG PAY | 5.43 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-15 00:00:00 | 12:27:00 | 2.82 | REG PAY | 2.82 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-15 00:00:00 | 06:30:00 | 0.5 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-15 00:00:00 | 06:30:00 | 5.45 | REG PAY | 5.45 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-16 00:00:00 | 12:18:00 | 2.36 | REG PAY | 2.36 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-16 00:00:00 | 06:36:00 | 0.48 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-16 00:00:00 | 06:36:00 | 5.22 | REG PAY | 5.22 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-17 00:00:00 | 11:16:00 | 1.16 | REG PAY | 1.16 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-17 00:00:00 | 12:26:00 | 2.14 | EDU | 2.14 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-17 00:00:00 | 06:32:00 | 0.52 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-17 00:00:00 | 06:32:00 | 4.22 | REG PAY | 4.22 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-18 00:00:00 | 12:22:00 | 2.46 | EDU | 2.46 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-18 00:00:00 | 06:37:00 | 0.44 | SHORT LUNCH | 0 | 0 | 1
200 | [NAME], [NAME] | Billing | 2024-04-18 00:00:00 | 06:37:00 | 5.31 | REG PAY | 5.31 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-19 00:00:00 | 06:31:00 | 0.65 | EDU | 0.65 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-19 00:00:00 | 07:10:00 | 5.15 | REG PAY | 5.15 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-02 00:00:00 | 12:00:00 | 1.58 | REG PAY | 1.58 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-02 00:00:00 | 06:20:00 | 0.42 | SHORT LUNCH | 0 | 0 | 1
200 | [NAME], [NAME] | Billing | 2024-04-02 00:00:00 | 06:20:00 | 5.25 | REG PAY | 5.25 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-03 00:00:00 | 12:05:00 | 2.85 | REG PAY | 2.85 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-03 00:00:00 | 06:43:00 | 0.51 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-03 00:00:00 | 06:43:00 | 4.85 | REG PAY | 4.85 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-04 00:00:00 | 11:55:00 | 3.4 | REG PAY | 3.4 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-04 00:00:00 | 06:27:00 | 0.5 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-04 00:00:00 | 06:27:00 | 4.97 | REG PAY | 4.97 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-05 00:00:00 | 12:20:00 | 2.45 | REG PAY | 2.45 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-05 00:00:00 | 06:35:00 | 0.48 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-05 00:00:00 | 06:35:00 | 5.27 | REG PAY | 5.27 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-08 00:00:00 | 11:51:00 | 3.22 | REG PAY | 3.22 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-08 00:00:00 | 06:45:00 | 0.47 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-08 00:00:00 | 06:45:00 | 4.63 | REG PAY | 4.63 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-09 00:00:00 | 12:02:00 | 2.93 | REG PAY | 2.93 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-04-09 00:00:00 | 06:31:00 | 0.51 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-04-09 00:00:00 | 06:31:00 | 5 | REG PAY | 5 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-05-01 00:00:00 | 11:04:00 | 4.06 | REG PAY | 4.06 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-05-01 00:00:00 | 06:35:00 | 0.5 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-05-01 00:00:00 | 06:35:00 | 3.99 | REG PAY | 3.99 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-05-02 00:00:00 | 11:11:00 | 3.55 | REG PAY | 3.55 | 0 | 0
200 | [NAME], [NAME] | Billing | 2024-05-02 00:00:00 | 06:39:00 | 0.48 | LUNCH NP | 0 | 1 | 0
200 | [NAME], [NAME] | Billing | 2024-05-02 00:00:00 | 06:39:00 | 4.05 | REG PAY | 4.05 | 0 | 0