Spreadsheet: 857926d1706779997-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-01-feb-v1
Sheet: CALDERA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
CALDERA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  | Mo. [NAME]: |  |  | Hrly [NAME].: |  |  |  |  |  | Position: | [NAME]
 |  |  |  |  |  |  |  |  |  | Shift: | Swing |  | Stipend/UA: |  |  | Wk Equiv.: |  |  |  |  |  | Union: | [NAME]
LEAVE USAGE
TYPE | V | S | SF | CTO | HCTO | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
2023-11-06 00:00:00 |  |  |  | 0.5 |  |  |  |  |  | 1 | 2023-10-29 00:00:00 | 2023-11-04 00:00:00
2023-11-13 00:00:00 |  |  | 10 |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-11 00:00:00
11/26-27/2023 |  | 20 |  |  |  |  |  |  |  | 3 | 2023-11-12 00:00:00 | 2023-11-18 00:00:00
 |  |  |  |  |  |  |  |  |  | 4 | 2023-11-19 00:00:00 | 2023-11-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 5 | 2023-11-26 00:00:00 | 2023-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  | Total
TOTAL |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
 |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
OVERTIME AUTHORIZED |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE
SHIFT COVERAGE - VACANT | 2023-11-05 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1 |  |  |  |  |  | Difference:
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 10 | HG6 | 213-425HP |  | 11
SHIFT COVERAGE - VACANT | 2023-11-12 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 14 |  |  |  |  |  | 00:00:00 | CALDERA | 10 | 2023-11-11 00:00:00 | HG6 |  |  |  | 0 | 66666
DISPATCH TRAINER MEETING | 2023-11-16 00:00:00 | 1300 | 1400 | 3 | CTO | 213-425P |  |  |  |  |  | 22222 | 00:00:00 | CALDERA | 2 | 2023-11-11 00:00:00 | OTPR |  |  | CALDERA | 0 | 66666
THANKSGIVING - RDO | 2023-11-23 00:00:00 |  |  | 10 | RDO HOL PD | 213-425OT5 |  |  |  |  |  | 22222 | 00:00:00 | CALDERA | 2 | 2023-11-18 00:00:00 | OTPR |  |  | CALDERA | 0 | 66666
SHIFT COVERAGE - VACANT | 2023-11-24 00:00:00 | 1600 | 1800 | 2 | OTPR | 213-425P | 1 |  |  |  |  | 22222 | 00:00:00 | CALDERA | 3 | 2023-11-18 00:00:00 | CTO |  |  | CALDERA | 0 | 66666
Total |  |  |  |  |  |  |  |  |  |  |  | 22222 | 00:00:00 | CALDERA | 2 | 2023-11-25 00:00:00 | OTPR |  |  | CALDERA | 0 | 66666
 |  |  |  | Regular Shift Differential Hours: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  | Total Shift Differential Hours to Pay: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALDERA | 0 | 66666