Spreadsheet: 812641d1673293402-formula-to-return-a-value-with-a-variable-date-range-and-multiple-criteria-2022-12-21-active-timesheet-data-payroll-tracker-lorie-wip2
Sheet: TS TABLE

[NAME] | Time sheet submission DATE | WORK Date ACTUAL | Job # | SUBMITTED BY | *NEW* WORK TYPE | Crew LEAD | WORKER First Name | WORKER  Last Name | AB FIELD TICKET# | Unit | Unit3 | Unit4 | Field Hours HR1 | MOB-YARD HR1 | MOB MOVE (DRIVING) HR1 | Shop Time  - - Shop Travel HR2 | ADJ TIME - Missed or Banked Time PO | *NEW* DAYS OFF TRAVEL TIME  HR2   MOB | TOTAL HOURS | [NAME] Later | Half LOA | Full LOA | No LOA | ADJ LOA- Missed LOA HALF | ADJ LOA- Missed LOA FULL | [NAME] (MOB KM's) | Notes | DAYS OFF TRAVEL TIME  HR2   MOB | Travel Home/RT KMS   MOB | JOB# - Travel to/from Project Location  MOB | REG FIELD HRS | REG FIELD RATE | REG SHOP HRS | REG SHOP RATE | REG OT HRS | OT FIELD RATE | SHOP OT HRS | OT SHOP RATE | TOTAL HRS | TOTAL HRS-X-REF W/ COLUMN M = [NAME] | EMP PERS TRAVEL HRS HR2 | LOA - HALF | LOA - FULL | ADJ/MISSED LOA HALF | ADJ/MISSED LOA FULL | CELL BONUS | # OF TRUCK RENT | HR1 - TOTAL WAGE | HR2 - TOTAL WAGE | OT HR1 - TOTAL WAGE | [NAME] | HR2 - ADJ TIME - EMP PERS TRAVEL WAGE | STAT PAY | ADJ - MISSED OR BANKED TIME | LOA - HALF 58.00 | LOA - FULL 130.00 | CELL BONUS @15.00 | TRUCK RENT *60.00 | TOTAL NON-TAX GROSS | TOTAL TAXABLE GROSS PAY | STAT DATES | 2022-12-06 00:00:00 | 2023-01-02 00:00:00
 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 1
 | 2023-01-02 00:00:00 | 2023-01-02 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First | Last | stat pay
 | 2023-01-03 00:00:00 | 2023-01-03 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | 58.5
 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brent | [NAME]
 | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Troy | Allardice
 | 2023-01-06 00:00:00 | 2023-01-06 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Blixrud
 | 2023-01-07 00:00:00 | 2023-01-07 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Terrence | [NAME]
 | 2023-01-08 00:00:00 | 2023-01-08 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Drader
 | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Drader4
 | 2023-01-10 00:00:00 | 2023-01-10 00:00:00 | 597 | [NAME] | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Drader2
 | 2023-01-11 00:00:00 | 2023-01-11 00:00:00 | 597 | [NAME] | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rocan | Drader3
 | 2023-01-12 00:00:00 | 2023-01-12 00:00:00 | 597 | [NAME] | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Freese
 | 2023-01-13 00:00:00 | 2023-01-13 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Galenkamp
 | 2023-01-14 00:00:00 | 2023-01-14 00:00:00 | 597 | LORIE | ADMN | [NAME] | MELISSA | APPLE |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tyler | Ketzmerick
 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 795 | TROY | SHOP | TROY | TROY | ORANGE |  |  |  |  |  |  |  | 10.5 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emma | Sinclair
 | 2023-01-02 00:00:00 | 2023-01-02 00:00:00 | 795 | TROY | SHOP | TROY | TROY | ORANGE |  |  |  |  |  |  |  | 10 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Olivia | Sinclair4
 | 2023-01-03 00:00:00 | 2023-01-03 00:00:00 | 701 | TROY | ML | TROY | TROY | ORANGE |  |  |  |  | 4.5 |  |  | 6.5 |  |  |  |  |  | 1 |  |  |  |  | CWI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sinclair2
 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 | 701-795 | TROY | SHOP | TROY | TROY | ORANGE |  |  |  |  | 5 |  |  | 5 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sinclair3
 | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 701 | TROY | ML | TROY | TROY | ORANGE |  | 79702 | T50 | D102 | 10 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | CWI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tye | Skilton
 | 2023-01-06 00:00:00 | 2023-01-06 00:00:00 | 795 | TROY | SHOP | TROY | TROY | ORANGE |  | 21601 |  |  | 11 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Costantinos | [NAME]
 | 2023-01-07 00:00:00 | 2023-01-07 00:00:00 | 795 | TROY | SHOP | TROY | TROY | ORANGE |  | 21601 |  |  |  |  |  | 11 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doug | Thompson
 | 2023-01-08 00:00:00 | 2023-01-08 00:00:00 | 701 | TROY | ML | TROY | TROY | ORANGE |  | 79702 | T50 | D102 | 14 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | SUMMIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Trembecki
 | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | 701 | TROY | ML | TROY | TROY | ORANGE |  | 79702 | T50 | D102 | 15.5 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | SUMMIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lorie | Walsh
 | 2023-01-10 00:00:00 | 2023-01-10 00:00:00 | 701 | TROY | ML | TROY | TROY | ORANGE |  | 79702 | T50 | D102 | 10 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | SUMMIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | 2023-01-11 00:00:00 | 2023-01-11 00:00:00 | 701/799 | TROY | VAC/OPH | TROY | TROY | ORANGE |  | 72001 |  |  | 8.5 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | CDN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Wood
 | 2023-01-12 00:00:00 | 2023-01-12 00:00:00 | 710/701 | TROY | VAC | TROY | TROY | ORANGE |  | 71101 |  |  | 13 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | EID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 | 2023-01-13 00:00:00 | 2023-01-13 00:00:00 | 701 | TROY | ML | TROY | TROY | ORANGE |  | 79702 | T50 | D102 | 11 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | NO JOB LISTED + OPH SNOW REMOVAL
 | 2023-01-14 00:00:00 | 2023-01-14 00:00:00 | 799 | STU | OPH | STU | TROY | ORANGE |  | 21601 |  |  | 11 |  |  |  |  |  |  |  |  | 1
 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 | T61 |  | 8 |  | 2 |  |  |  |  |  |  | 1 |  |  |  | 200 | ROSE/TOON
 | 2023-01-02 00:00:00 | 2023-01-02 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 |  |  | 10 |  |  |  |  |  |  |  |  | 1
 | 2023-01-03 00:00:00 | 2023-01-03 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 | T77 | 21207 | 5 |  | 4 |  |  |  |  |  |  |  | 1 |  |  | 370 | ROSE/BROOKS
 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 | T77 | 21207 |  | 2.5 |  |  |  |  |  |  |  |  | 1
 | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 | T77 |  | 6 |  | 4 |  |  |  |  |  |  | 1
 | 2023-01-06 00:00:00 | 2023-01-06 00:00:00 | 592-598 | [NAME] | MGMT | [NAME] | BRENT | BARTLETT |  | 21703 | T77 |  | 9.5 |  |  |  |  |  |  |  |  | 1
 | 2023-01-07 00:00:00 | 2023-01-07 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 |  |  | 10 |  |  |  |  |  |  |  |  | 1
 | 2023-01-08 00:00:00 | 2023-01-08 00:00:00 | 592-598 | [NAME] | MGMT | BRENT | BRENT | BARTLETT |  | 21703 |  |  | 9.5 |  |  |  |  |  |  |  |  | 1
 | 2023-01-09 00:00:00 | 2023-01-09 00:00:00 | 592-598 | [NAME] | MGMT | BRENT | BRENT | BARTLETT |  | 21703 |  |  | 10 |  |  |  |  |  |  |  |  | 1
 | 2023-01-10 00:00:00 | 2023-01-10 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 |  |  | 11 |  |  |  |  |  |  |  |  | 1
 | 2023-01-11 00:00:00 | 2023-01-11 00:00:00 | 592-598 | BRENT | MGMT | BRENT | BRENT | BARTLETT |  | 21703 |  |  | 11 |  |  |  |  |  |  |  |  | 1
 | 2023-01-12 00:00:00 | 2023-01-12 00:00:00
 | 2023-01-13 00:00:00 | 2023-01-13 00:00:00
 | 2023-01-14 00:00:00 | 2023-01-14 00:00:00