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

Name | Date | Hrs | Job ID
Worker1 |  |  | Job 1
Worker2 |  |  | Job 2
Worker3 |  |  | Job 3
Worker4 |  |  | Job 4
Worker5 |  |  | Job 5
Worker6 |  |  | Job 6 |  | Row Labels | Sum of Hrs |  | Row Labels | Sum of Hrs |  | Sum of Hrs | Column Labels
Worker7 |  |  | Job 7 |  | Job 1 | 67 |  | Worker1 | 54 |  | Row Labels | Worker1 | Worker10 | Worker2 | Worker3 | Worker4 | Worker5 | Worker6 | Worker7 | Worker8 | Worker9 | Grand Total
Worker8 |  |  | Job 1 |  | Job 2 | 81 |  | Worker10 | 47 |  | May |  | 13 | 8 | 2 |  |  |  |  |  | 6 | 29
Worker9 |  |  | Job 2 |  | Job 3 | 66 |  | Worker2 | 55 |  | Jun | 48 | 20 | 31 | 26 | 26 | 28 | 49 | 37 | 16 | 28 | 309
Worker10 |  |  | Job 3 |  | Job 4 | 63 |  | Worker3 | 42 |  | Jul | 6 | 14 | 16 | 14 | 20 | 19 | 8 | 21 | 24 | 12 | 154
Worker1 |  |  | Job 4 |  | Job 5 | 83 |  | Worker4 | 46 |  | Grand Total | 54 | 47 | 55 | 42 | 46 | 47 | 57 | 58 | 40 | 46 | 492
Worker2 |  |  | Job 5 |  | Job 6 | 62 |  | Worker5 | 47
Worker3 |  |  | Job 6 |  | Job 7 | 70 |  | Worker6 | 57
Worker4 |  |  | Job 7 |  | Grand Total | 492 |  | Worker7 | 58
Worker5 |  |  | Job 1 |  |  |  |  | Worker8 | 40
Worker6 |  |  | Job 2 |  |  |  |  | Worker9 | 46
Worker7 |  |  | Job 3 |  |  |  |  | Grand Total | 492
Worker8 |  |  | Job 4
Worker9 |  |  | Job 5 |  |  |  |  |  |  |  | Sum of Hrs | Column Labels
Worker10 |  |  | Job 6 |  |  |  |  |  |  |  | Row Labels | Job 1 | Job 2 | Job 3 | Job 4 | Job 5 | Job 6 | Job 7 | Grand Total
Worker1 |  |  | Job 7 |  |  |  |  |  |  |  | May |  |  | 6 |  | 14 | 9 |  | 29
Worker2 |  |  | Job 1 |  |  |  |  |  |  |  | Jun | 39 | 52 | 38 | 38 | 47 | 43 | 52 | 309
Worker3 |  |  | Job 2 |  |  |  |  |  |  |  | Jul | 28 | 29 | 22 | 25 | 22 | 10 | 18 | 154
Worker4 |  |  | Job 3 |  |  |  |  |  |  |  | Grand Total | 67 | 81 | 66 | 63 | 83 | 62 | 70 | 492
Worker5 |  |  | Job 4
Worker6 |  |  | Job 5
Worker7 |  |  | Job 6
Worker8 |  |  | Job 7
Worker9 |  |  | Job 1
Worker10 |  |  | Job 2
Worker1 |  |  | Job 3
Worker2 |  |  | Job 4
Worker3 |  |  | Job 5
Worker4 |  |  | Job 6
Worker5 |  |  | Job 7
Worker6 |  |  | Job 1
Worker7 |  |  | Job 2
Worker8 |  |  | Job 3
Worker9 |  |  | Job 4
Worker10 |  |  | Job 5
Worker1 |  |  | Job 6
Worker2 |  |  | Job 7
Worker3 |  |  | Job 1
Worker4 |  |  | Job 2
Worker5 |  |  | Job 3
Worker6 |  |  | Job 4
Worker7 |  |  | Job 5
Worker8 |  |  | Job 6
Worker9 |  |  | Job 7
Worker10 |  |  | Job 1
Worker1 |  |  | Job 2
Worker2 |  |  | Job 3
Worker3 |  |  | Job 4
Worker4 |  |  | Job 5
Worker5 |  |  | Job 6
Worker6 |  |  | Job 7
Worker7 |  |  | Job 1
Worker8 |  |  | Job 2
Worker9 |  |  | Job 3
Worker10 |  |  | Job 4
Worker1 |  |  | Job 5
Worker2 |  |  | Job 6
Worker3 |  |  | Job 7
Worker4 |  |  | Job 1
Worker5 |  |  | Job 2
Worker6 |  |  | Job 3
Worker7 |  |  | Job 4
Worker8 |  |  | Job 5
Worker9 |  |  | Job 6
Worker10 |  |  | Job 7
Worker1 |  |  | Job 1
Worker2 |  |  | Job 2
Worker3 |  |  | Job 3
Worker4 |  |  | Job 4
Worker5 |  |  | Job 5
Worker6 |  |  | Job 6
Worker7 |  |  | Job 7
Worker8 |  |  | Job 1
Worker9 |  |  | Job 2
Worker10 |  |  | Job 3
Worker1 |  |  | Job 4
Worker2 |  |  | Job 5
Worker3 |  |  | Job 6
Worker4 |  |  | Job 7
Worker5 |  |  | Job 1
Worker6 |  |  | Job 2
Worker7 |  |  | Job 3
Worker8 |  |  | Job 4
Worker9 |  |  | Job 5
Worker10 |  |  | Job 6
Worker1 |  |  | Job 7
Worker2 |  |  | Job 1
Worker3 |  |  | Job 2
Worker4 |  |  | Job 3
Worker5 |  |  | Job 4
Worker6 |  |  | Job 5
Worker7 |  |  | Job 6
Worker8 |  |  | Job 7
Worker9 |  |  | Job 1
Worker10 |  |  | Job 2