Spreadsheet: 685103d1593723214-help-with-a-formula-function-for-totaling-hours-for-a-job-labour-analysis
Sheet: Employee 2

Labour Costs
 |  |  | 24
 |  |  |  | 18-1013 |  | 20-1001 |  | 19-1011 |  | 19-1013 |  | 19-1015 |  | 19-1020 |  | 19-1021 |  | 19-1022 |  | 19-1029 |  | 19-1032 |  | 19-1035 |  | 19-1036 |  | 20-1002 |  | 20-1003 |  | 20-1004 |  | 20-1005 |  | 20-1006 |  | 20-1007 |  | 20-1008 |  | 20-1009 |  | 20-1010 |  | 20-1011 |  | 20-1012 |  | 20-1013 |  | 20-1014 |  | 20-1015 |  | 20-1016
 | Pay Period |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours
1 | Dec 29-Jan 3 |  |  |  |  |  |  |  |  |  | 24.5
2 | Jan 5 - 11 |  |  |  |  |  |  |  |  |  | 39.5
3 | Jan 12-18 |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
4 | Jan 19-25 |  |  |  |  |  |  |  |  |  | 34.5
5 | Jan 26-Feb 1 |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
6 | Feb 2-8 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 43.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
7 | Feb 9-15 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 27.5 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
8 | Feb 16 - 22 |  |  |  |  |  |  | 0 |  |  |  |  | 27.5
9 | Feb 23 - 29 |  |  |  |  |  |  | 0 |  |  |  |  | 41.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
10 | [NAME] |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37.5
11 | [NAME] |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5 |  |  |  | 26.5
12 | [NAME] |  |  |  |  |  |  | NO WORK
13 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34.5
14 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
15 | Apr 5 - 11
16 | Apr 12 - 18
17 | April 19 - 25 |  |  |  |  |  |  |  |  |  |  |  | NO WORK
18 | Apr 26 - May 2 |  |  |  |  |  |  |  |  |  |  |  | NO WORK
19 | May 3 - 9
20 | May 10 - 16
21 | May 17  - 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.5
22 | May 24 - 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
23 | May 30 -June 6 |  |  |  | 6 | 144 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5
24 | June 7 - 13 |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
25 | June 14 - 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 8
26 | June 21 - 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
27 | June 28 - July 4
28 | July 5 - 11
29 | July 12  18
30 | July 19 - 25
31 | July 26 - Aug 1
32 | Aug 2 - 8
33 | Aug 9 - 15
34 | Aug 16 - 22
35 | Aug 23 - 29
36 | Aug 30-Sept 5
37 | Sept 6 - 12
38 | Sept 13 - 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
39 | Sept 20 - 26
40 | Sept 27 - Oct 3
41 | [NAME]
42 | Oct 11 - 17
43 | Oct 18 - 24
44 | Oct 25 - 31
45 | Nov 1 - 7
46 | Nov 8 - 14
47 | Nov 15 - 21
48 | Nov 22 - 28
49 | Nov 29 - Dec 5
50 | Dec 6 - 12
51 | Dec 13 - 19
52 | Dec 20 - 26
 | Dec 27 - Jan 2