Spreadsheet: 169142d1342710623-total-hours-worked-per-job-or-worker-pivot-table-demo-x-4
Sheet: Sheet2

 |  |  |  |  |  |  |  | ORIGINAL |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR PAYROLL
 |  | ED | EDOT | R | ROT |  |  |  |  | ED | EDOT | R | ROT | PRE |  |  |  | OVER 8 | OVER 40 |  |  |  |  | ED | EDOT | R | ROT | TOTAL HRS |  | OVER 8 | OVER 40
 |  | 8 | 0.5 |  | 1 |  |  |  | ANGEL | 39.5 | 12 | 7.5 | 3 |  |  |  |  |  |  |  |  | X | ANGEL | 29 | 9.75 | 12 | 4.75
 |  |  |  | 8 | 1 |  |  |  | CHUCHO | 39.5 | 12 | 2 | 2 |  |  |  |  |  |  |  |  | X | CHUCHO | 32 | 11.75 | 9 | 0
 |  |  |  | 8 | 1.25 |  |  |  | ANDREW | 39 | 12 | 2 | 2 |  |  |  |  |  |  |  |  | X | ANDREW | 16.5 | 0 | 9 | 0
 |  | 2.5 | 10 | 5.5 |  |  |  |  | CARLOS | 31 | 16.25 | 0 | 0 | 12.5 |  |  |  |  |  |  |  | X | CARLOS | 40 | 7 | 1 | 0
 |  |  |  |  |  |  |  |  | JESUS T | 35.75 | 10 | 0 | 0.75 | 6 |  |  |  |  |  |  |  | X | JESUS T | 40 | 5 | 1 | 0.75
 |  | 8 | 7.75 |  |  |  |  |  | [NAME] | 31.25 | 6 | 0 | 0 | 12.5 |  |  |  |  |  |  |  | X | [NAME] | 40 | 7.25 | 1 | 0
 |  |  |  |  |  |  |  |  | JESUS J | 13.5 | 8.5 | 17 | 3.75 | 12.5 |  |  |  |  |  |  |  | X | JESUS J | 24 | 5.75 | 17 | 2.75
 |  |  |  |  |  |  |  |  | MACIEJ | 28.75 | 2.75 | 0 | 1 | 13.5 |  |  |  |  |  |  |  | X | MACIEJ | 40 | 8 | 2 | 0
 |  |  |  |  |  |  |  |  | [NAME] | 28.75 | 13.75 | 0 | 1.5 | 13.5 |  |  |  |  |  |  |  | X | [NAME] | 38 | 10 | 2 | 0
 |  |  |  |  |  |  |  |  | STIX | 28.75 | 1.75 | 0 | 1 | 13.5 |  |  |  |  |  |  |  | X | STIX | 37.5 | 11.25 | 4.5 | 1.5
 |  |  |  |  |  |  |  |  | GALLO | 14 | 7 | 26 | 4.75 |  |  |  |  |  |  |  |  | X | GALLO | 28 | 4.25 | 12 | 1.25
 |  |  |  |  |  |  |  |  | CHINO | 26.5 | 13.25 | 10.5 | 2 | 6 |  |  |  |  |  |  |  | X | CHINO | 24.5 | 9.5 | 18 | 5.25
 |  |  |  |  |  |  |  |  | CHRIS | 18.5 | 18.25 | 21.5 | 3.25 |  |  |  |  |  |  |  |  | X | CHRIS | 17 | 0 | 25.75 | 0
 |  |  |  |  |  |  |  |  | CELSO | 0 | 0 | 40 | 11 |  |  |  |  |  |  |  |  | R | CELSO | 0 | 0 | 40 | 3
 |  |  |  |  |  |  |  |  | SAUL | 16.75 | 5.75 | 23.25 | 2.5 |  |  |  |  |  |  |  |  | R | SAUL | 0 | 0 | 40 | 3.75
 |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 40 | 0.75 |  |  |  |  |  |  |  |  | R | [NAME] | 0 | 0 | 40 | 0
 |  |  |  |  |  |  |  |  | NINJA | 0 | 0 | 40 | 4 |  |  |  |  |  |  |  |  | R | NINJA | 0 | 0 | 40 | 0
 |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 29.5 | 0 |  |  |  |  |  |  |  |  | R | [NAME] | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 40 | 9.25 |  |  |  |  |  |  |  |  | R | [NAME] | 0 | 0 | 40 | 4
 |  |  |  |  |  |  |  |  | [NAME] | 6.5 | 3.75 | 33.5 | 6 |  |  |  |  |  |  |  |  | X | [NAME] | 0 | 0 | 42 | 0.5
 |  |  |  |  |  |  |  | ED | EDOT | R | ROT | TOTAL HRS |  | OVER 8 | OVER 40
 |  |  |  |  |  |  | ANDREW | 15 | 1.5 | 9 | 0
 |  |  |  |  |  |  |  | 16.5 | 0 | 9 | 0
 |  |  |  |  |  |  | JESUS T | 39 | 6 | 1 | 0.75
 |  |  |  |  |  |  | [NAME] | 38 | 9.25 | 1 | 0 |  |  |  |  |  | 1HR REDUCTION FOR 40
 |  |  |  |  |  |  |  | 40 | 7.25 | 1 | 0 |  |  |  |  |  | 1HR FOR BBQ
 |  |  |  |  |  |  | MACIEJ | 37.5 | 10.5 | 0 | 0
 |  |  |  |  |  |  |  | 40 | 8
 |  |  |  |  |  |  | [NAME] | 36.5 | 11.5 | 2 | 0
 |  |  |  |  |  |  |  | 38 | 10 | 2 | 0
 |  |  |  |  |  |  | STIX | 37.5 | 11.25 | 2.5 | 1.5
 |  |  |  |  |  |  | GALLO | 19.5 | 12.75 | 12 | 1.25 |  |  |  |  |  | 8.5 | RE - ALLOCATE
 |  |  |  |  |  |  |  | 28 | 4.25 | 12 | 1.25
 |  |  |  |  |  |  | CHINO | 21.5 | 12.5 | 18 | 5.25
 |  |  |  |  |  |  | CHRIS | 16.5 | 0.5 | 24.5 | 2.5
 |  |  |  |  |  |  |  | 16.25 | 0.25 | 24.5 | 0.25