Spreadsheet: 685127d1593751651-help-with-a-formula-function-for-totaling-hours-for-a-job-dmferd
Sheet: Employee 3

 |  |  | 30
 |  |  |  | 18-1013 |  | 20-1001 |  | 19-1011 |  | 19-1011 |  | 19-1013 |  | 19-1015 |  | 19-1020 |  | 19-1021 |  | 19-1022 |  | 19-1026 |  | 19-1029 |  | 19-1032 |  | 19-1035 |  | 19-1036 |  | 20-1002 |  | 20-1003 |  | 20-1004 |  | 20-1006 |  | 20-1007 |  | 20-1008 |  | 20-1009 |  | 20-1010 |  | 20-1011 |  | 20-1012 |  | 20-1013 |  | 20-1014 |  | 20-1015 |  | 20-1016
PP | Pay Period |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | Hours |  | 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 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 18
2 | Jan 5 - 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45.5
3 | Jan 12-18 |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 36
4 | Jan 19-25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
5 | Jan 26-Feb 1 |  |  |  |  |  |  |  | 7.5 |  |  |  |  |  | 45
6 | Feb 2-8 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 21
7 | Feb 9-15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 20.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
8 | Feb 16 - 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28.5
9 | Feb 23 - 29 |  | 32 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8
10 | [NAME] |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  | 4
11 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30.5 |  | 9 |  |  |  | 2.5
12 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
13 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.5 |  |  |  |  |  | 26
14 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 34.5
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 |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  | 4
21 | May 17  - 23 |  |  |  |  |  | 16.5 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
22 | May 24 - 30 |  |  |  |  |  | 15 |  |  |  |  |  |  |  | 7.5 |  | 13
23 | May 30 -June 6 |  |  |  |  |  | 13.5
24 | June 7 - 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
25 | June 14 - 20
26 | June 21 - 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
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
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