Spreadsheet: 41777d1240305372-cumulative-sum-for-weekly-average-hours-over-a-month-johns-working-hours-alis1
Sheet: Sheet1

[NAME]'s Working Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 7
Counter | Date | Day | Start | Lunch | Finish | Daily Total Hours | Daily Working Hours | Weekly Total Hours | Weekly Working Hours | Average Weekly Working Hours per Month | Average Weekly Total Hours per Month |  |  |  |  |  |  | Start |  |  | Finish
1 | 2009-04-12 00:00:00 | Sun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H4 |  |  | H10
2 | 2009-04-13 00:00:00 | Mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 Worked Hours
3 | 2009-04-14 00:00:00 | Tue | 08:15:00 | 00:30:00 | 19:45:00 | 11.5 | 11
4 | 2009-04-15 00:00:00 | Wed | 07:00:00 | 01:00:00 | 18:45:00 | 11.75 | 10.75
5 | 2009-04-16 00:00:00 | Thu | 08:00:00 | 00:30:00 | 20:15:00 | 12.25 | 11.75
6 | 2009-04-17 00:00:00 | Fri | 07:00:00
7 | 2009-04-18 00:00:00 | Sat |  |  |  |  |  | 35.5 | 33.5
8 | 2009-04-19 00:00:00 | Sun
9 | 2009-04-20 00:00:00 | Mon
10 | 2009-04-21 00:00:00 | Tue
11 | 2009-04-22 00:00:00 | Wed
12 | 2009-04-23 00:00:00 | Thu
13 | 2009-04-24 00:00:00 | Fri
14 | 2009-04-25 00:00:00 | Sat |  |  |  |  |  | 0 | 0
15 | 2009-04-26 00:00:00 | Sun
16 | 2009-04-27 00:00:00 | Mon
17 | 2009-04-28 00:00:00 | Tue
18 | 2009-04-29 00:00:00 | Wed
19 | 2009-04-30 00:00:00 | Thu
20 | 2009-05-01 00:00:00 | Fri
21 | 2009-05-02 00:00:00 | Sat |  |  |  |  |  | 0 | 0
22 | 2009-05-03 00:00:00 | Sun
23 | 2009-05-04 00:00:00 | Mon
24 | 2009-05-05 00:00:00 | Tue
25 | 2009-05-06 00:00:00 | Wed
26 | 2009-05-07 00:00:00 | Thu
27 | 2009-05-08 00:00:00 | Fri
28 | 2009-05-09 00:00:00 | Sat |  |  |  |  |  | 0 | 0
29 | 2009-05-10 00:00:00 | Sun
30 | 2009-05-11 00:00:00 | Mon
31 | 2009-05-12 00:00:00 | Tue
32 | 2009-05-13 00:00:00 | Wed
33 | 2009-05-14 00:00:00 | Thu
34 | 2009-05-15 00:00:00 | Fri
35 | 2009-05-16 00:00:00 | Sat |  |  |  |  |  | 0 | 0
36 | 2009-05-17 00:00:00 | Sun
37 | 2009-05-18 00:00:00 | Mon
38 | 2009-05-19 00:00:00 | Tue
39 | 2009-05-20 00:00:00 | Wed
40 | 2009-05-21 00:00:00 | Thu
41 | 2009-05-22 00:00:00 | Fri
42 | 2009-05-23 00:00:00 | Sat |  |  |  |  |  | 0 | 0
43 | 2009-05-24 00:00:00 | Sun
44 | 2009-05-25 00:00:00 | Mon
45 | 2009-05-26 00:00:00 | Tue
46 | 2009-05-27 00:00:00 | Wed
47 | 2009-05-28 00:00:00 | Thu
48 | 2009-05-29 00:00:00 | Fri
49 | 2009-05-30 00:00:00 | Sat |  |  |  |  |  | 0 | 0
50 | 2009-05-31 00:00:00 | Sun
51 | 2009-06-01 00:00:00 | Mon
52 | 2009-06-02 00:00:00 | Tue
53 | 2009-06-03 00:00:00 | Wed
54 | 2009-06-04 00:00:00 | Thu
55 | 2009-06-05 00:00:00 | Fri
56 | 2009-06-06 00:00:00 | Sat |  |  |  |  |  | 0 | 0
57 | 2009-06-07 00:00:00 | Sun
58 | 2009-06-08 00:00:00 | Mon
59 | 2009-06-09 00:00:00 | Tue
60 | 2009-06-10 00:00:00 | Wed
61 | 2009-06-11 00:00:00 | Thu
62 | 2009-06-12 00:00:00 | Fri
63 | 2009-06-13 00:00:00 | Sat |  |  |  |  |  | 0 | 0
64 | 2009-06-14 00:00:00 | Sun
65 | 2009-06-15 00:00:00 | Mon
66 | 2009-06-16 00:00:00 | Tue
67 | 2009-06-17 00:00:00 | Wed
68 | 2009-06-18 00:00:00 | Thu
69 | 2009-06-19 00:00:00 | Fri
70 | 2009-06-20 00:00:00 | Sat |  |  |  |  |  | 0 | 0
71 | 2009-06-21 00:00:00 | Sun
72 | 2009-06-22 00:00:00 | Mon
73 | 2009-06-23 00:00:00 | Tue
74 | 2009-06-24 00:00:00 | Wed
75 | 2009-06-25 00:00:00 | Thu
76 | 2009-06-26 00:00:00 | Fri
77 | 2009-06-27 00:00:00 | Sat |  |  |  |  |  | 0 | 0
78 | 2009-06-28 00:00:00 | Sun
79 | 2009-06-29 00:00:00 | Mon
80 | 2009-06-30 00:00:00 | Tue
81 | 2009-07-01 00:00:00 | Wed
82 | 2009-07-02 00:00:00 | Thu
83 | 2009-07-03 00:00:00 | Fri
84 | 2009-07-04 00:00:00 | Sat |  |  |  |  |  | 0 | 0
85 | 2009-07-05 00:00:00 | Sun
86 | 2009-07-06 00:00:00 | Mon
87 | 2009-07-07 00:00:00 | Tue
88 | 2009-07-08 00:00:00 | Wed
89 | 2009-07-09 00:00:00 | Thu
90 | 2009-07-10 00:00:00 | Fri
91 | 2009-07-11 00:00:00 | Sat |  |  |  |  |  | 0 | 0
92 | 2009-07-12 00:00:00 | Sun
93 | 2009-07-13 00:00:00 | Mon
94 | 2009-07-14 00:00:00 | Tue
95 | 2009-07-15 00:00:00 | Wed
96 | 2009-07-16 00:00:00 | Thu
97 | 2009-07-17 00:00:00 | Fri
98 | 2009-07-18 00:00:00 | Sat |  |  |  |  |  | 0 | 0
99 | 2009-07-19 00:00:00 | Sun
100 | 2009-07-20 00:00:00 | Mon
101 | 2009-07-21 00:00:00 | Tue
102 | 2009-07-22 00:00:00 | Wed
103 | 2009-07-23 00:00:00 | Thu
104 | 2009-07-24 00:00:00 | Fri
105 | 2009-07-25 00:00:00 | Sat |  |  |  |  |  | 0 | 0
106 | 2009-07-26 00:00:00 | Sun
107 | 2009-07-27 00:00:00 | Mon
108 | 2009-07-28 00:00:00 | Tue
109 | 2009-07-29 00:00:00 | Wed
110 | 2009-07-30 00:00:00 | Thu
111 | 2009-07-31 00:00:00 | Fri
112 | 2009-08-01 00:00:00 | Sat |  |  |  |  |  | 0 | 0
113 | 2009-08-02 00:00:00 | Sun
114 | 2009-08-03 00:00:00 | Mon
115 | 2009-08-04 00:00:00 | Tue
116 | 2009-08-05 00:00:00 | Wed
117 | 2009-08-06 00:00:00 | Thu
118 | 2009-08-07 00:00:00 | Fri
119 | 2009-08-08 00:00:00 | Sat |  |  |  |  |  | 0 | 0
120 | 2009-08-09 00:00:00 | Sun
121 | 2009-08-10 00:00:00 | Mon
122 | 2009-08-11 00:00:00 | Tue
123 | 2009-08-12 00:00:00 | Wed
124 | 2009-08-13 00:00:00 | Thu
125 | 2009-08-14 00:00:00 | Fri
126 | 2009-08-15 00:00:00 | Sat |  |  |  |  |  | 0 | 0
127 | 2009-08-16 00:00:00 | Sun
128 | 2009-08-17 00:00:00 | Mon
129 | 2009-08-18 00:00:00 | Tue
130 | 2009-08-19 00:00:00 | Wed
131 | 2009-08-20 00:00:00 | Thu
132 | 2009-08-21 00:00:00 | Fri
133 | 2009-08-22 00:00:00 | Sat |  |  |  |  |  | 0 | 0
134 | 2009-08-23 00:00:00 | Sun
135 | 2009-08-24 00:00:00 | Mon
136 | 2009-08-25 00:00:00 | Tue
137 | 2009-08-26 00:00:00 | Wed
138 | 2009-08-27 00:00:00 | Thu
139 | 2009-08-28 00:00:00 | Fri
140 | 2009-08-29 00:00:00 | Sat |  |  |  |  |  | 0 | 0
141 | 2009-08-30 00:00:00 | Sun
142 | 2009-08-31 00:00:00 | Mon
143 | 2009-09-01 00:00:00 | Tue
144 | 2009-09-02 00:00:00 | Wed
145 | 2009-09-03 00:00:00 | Thu
146 | 2009-09-04 00:00:00 | Fri
147 | 2009-09-05 00:00:00 | Sat |  |  |  |  |  | 0 | 0
148 | 2009-09-06 00:00:00 | Sun
149 | 2009-09-07 00:00:00 | Mon
150 | 2009-09-08 00:00:00 | Tue
151 | 2009-09-09 00:00:00 | Wed
152 | 2009-09-10 00:00:00 | Thu
153 | 2009-09-11 00:00:00 | Fri
154 | 2009-09-12 00:00:00 | Sat |  |  |  |  |  | 0 | 0
155 | 2009-09-13 00:00:00 | Sun
156 | 2009-09-14 00:00:00 | Mon
157 | 2009-09-15 00:00:00 | Tue
158 | 2009-09-16 00:00:00 | Wed
159 | 2009-09-17 00:00:00 | Thu
160 | 2009-09-18 00:00:00 | Fri
161 | 2009-09-19 00:00:00 | Sat |  |  |  |  |  | 0 | 0
162 | 2009-09-20 00:00:00 | Sun
163 | 2009-09-21 00:00:00 | Mon
164 | 2009-09-22 00:00:00 | Tue
165 | 2009-09-23 00:00:00 | Wed
166 | 2009-09-24 00:00:00 | Thu
167 | 2009-09-25 00:00:00 | Fri
168 | 2009-09-26 00:00:00 | Sat |  |  |  |  |  | 0 | 0
169 | 2009-09-27 00:00:00 | Sun
170 | 2009-09-28 00:00:00 | Mon
171 | 2009-09-29 00:00:00 | Tue
172 | 2009-09-30 00:00:00 | Wed
173 | 2009-10-01 00:00:00 | Thu
174 | 2009-10-02 00:00:00 | Fri
175 | 2009-10-03 00:00:00 | Sat |  |  |  |  |  | 0 | 0
176 | 2009-10-04 00:00:00 | Sun
177 | 2009-10-05 00:00:00 | Mon
178 | 2009-10-06 00:00:00 | Tue
179 | 2009-10-07 00:00:00 | Wed
180 | 2009-10-08 00:00:00 | Thu
181 | 2009-10-09 00:00:00 | Fri
182 | 2009-10-10 00:00:00 | Sat |  |  |  |  |  | 0 | 0
183 | 2009-10-11 00:00:00 | Sun
184 | 2009-10-12 00:00:00 | Mon
185 | 2009-10-13 00:00:00 | Tue
186 | 2009-10-14 00:00:00 | Wed
187 | 2009-10-15 00:00:00 | Thu
188 | 2009-10-16 00:00:00 | Fri
189 | 2009-10-17 00:00:00 | Sat |  |  |  |  |  | 0 | 0
190 | 2009-10-18 00:00:00 | Sun
191 | 2009-10-19 00:00:00 | Mon
192 | 2009-10-20 00:00:00 | Tue
193 | 2009-10-21 00:00:00 | Wed
194 | 2009-10-22 00:00:00 | Thu
195 | 2009-10-23 00:00:00 | Fri
196 | 2009-10-24 00:00:00 | Sat |  |  |  |  |  | 0 | 0
197 | 2009-10-25 00:00:00 | Sun
198 | 2009-10-26 00:00:00 | Mon
199 | 2009-10-27 00:00:00 | Tue
200 | 2009-10-28 00:00:00 | Wed
201 | 2009-10-29 00:00:00 | Thu
202 | 2009-10-30 00:00:00 | Fri
203 | 2009-10-31 00:00:00 | Sat |  |  |  |  |  | 0 | 0
204 | 2009-11-01 00:00:00 | Sun
205 | 2009-11-02 00:00:00 | Mon
206 | 2009-11-03 00:00:00 | Tue
207 | 2009-11-04 00:00:00 | Wed
208 | 2009-11-05 00:00:00 | Thu
209 | 2009-11-06 00:00:00 | Fri
210 | 2009-11-07 00:00:00 | Sat |  |  |  |  |  | 0 | 0
211 | 2009-11-08 00:00:00 | Sun
212 | 2009-11-09 00:00:00 | Mon
213 | 2009-11-10 00:00:00 | Tue
214 | 2009-11-11 00:00:00 | Wed
215 | 2009-11-12 00:00:00 | Thu
216 | 2009-11-13 00:00:00 | Fri
217 | 2009-11-14 00:00:00 | Sat |  |  |  |  |  | 0 | 0
218 | 2009-11-15 00:00:00 | Sun
219 | 2009-11-16 00:00:00 | Mon
220 | 2009-11-17 00:00:00 | Tue
221 | 2009-11-18 00:00:00 | Wed
222 | 2009-11-19 00:00:00 | Thu
223 | 2009-11-20 00:00:00 | Fri
224 | 2009-11-21 00:00:00 | Sat |  |  |  |  |  | 0 | 0
225 | 2009-11-22 00:00:00 | Sun
226 | 2009-11-23 00:00:00 | Mon
227 | 2009-11-24 00:00:00 | Tue
228 | 2009-11-25 00:00:00 | Wed
229 | 2009-11-26 00:00:00 | Thu
230 | 2009-11-27 00:00:00 | Fri
231 | 2009-11-28 00:00:00 | Sat |  |  |  |  |  | 0 | 0
232 | 2009-11-29 00:00:00 | Sun
233 | 2009-11-30 00:00:00 | Mon
234 | 2009-12-01 00:00:00 | Tue
235 | 2009-12-02 00:00:00 | Wed
236 | 2009-12-03 00:00:00 | Thu
237 | 2009-12-04 00:00:00 | Fri
238 | 2009-12-05 00:00:00 | Sat |  |  |  |  |  | 0 | 0
239 | 2009-12-06 00:00:00 | Sun
240 | 2009-12-07 00:00:00 | Mon
241 | 2009-12-08 00:00:00 | Tue
242 | 2009-12-09 00:00:00 | Wed
243 | 2009-12-10 00:00:00 | Thu
244 | 2009-12-11 00:00:00 | Fri
245 | 2009-12-12 00:00:00 | Sat |  |  |  |  |  | 0 | 0
246 | 2009-12-13 00:00:00 | Sun
247 | 2009-12-14 00:00:00 | Mon
248 | 2009-12-15 00:00:00 | Tue
249 | 2009-12-16 00:00:00 | Wed
250 | 2009-12-17 00:00:00 | Thu
251 | 2009-12-18 00:00:00 | Fri
252 | 2009-12-19 00:00:00 | Sat |  |  |  |  |  | 0 | 0
253 | 2009-12-20 00:00:00 | Sun
254 | 2009-12-21 00:00:00 | Mon
255 | 2009-12-22 00:00:00 | Tue
256 | 2009-12-23 00:00:00 | Wed
257 | 2009-12-24 00:00:00 | Thu
258 | 2009-12-25 00:00:00 | Fri
259 | 2009-12-26 00:00:00 | Sat |  |  |  |  |  | 0 | 0
260 | 2009-12-27 00:00:00 | Sun
261 | 2009-12-28 00:00:00 | Mon
262 | 2009-12-29 00:00:00 | Tue
263 | 2009-12-30 00:00:00 | Wed
264 | 2009-12-31 00:00:00 | Thu
265 | 2010-01-01 00:00:00 | Fri
266 | 2010-01-02 00:00:00 | Sat |  |  |  |  |  | 0 | 0
267 | 2010-01-03 00:00:00 | Sun
268 | 2010-01-04 00:00:00 | Mon
269 | 2010-01-05 00:00:00 | Tue
270 | 2010-01-06 00:00:00 | Wed
271 | 2010-01-07 00:00:00 | Thu
272 | 2010-01-08 00:00:00 | Fri
273 | 2010-01-09 00:00:00 | Sat |  |  |  |  |  | 0 | 0
274 | 2010-01-10 00:00:00 | Sun
275 | 2010-01-11 00:00:00 | Mon
276 | 2010-01-12 00:00:00 | Tue
277 | 2010-01-13 00:00:00 | Wed
278 | 2010-01-14 00:00:00 | Thu
279 | 2010-01-15 00:00:00 | Fri
280 | 2010-01-16 00:00:00 | Sat |  |  |  |  |  | 0 | 0
281 | 2010-01-17 00:00:00 | Sun
282 | 2010-01-18 00:00:00 | Mon
283 | 2010-01-19 00:00:00 | Tue
284 | 2010-01-20 00:00:00 | Wed
285 | 2010-01-21 00:00:00 | Thu
286 | 2010-01-22 00:00:00 | Fri
287 | 2010-01-23 00:00:00 | Sat |  |  |  |  |  | 0 | 0
288 | 2010-01-24 00:00:00 | Sun
289 | 2010-01-25 00:00:00 | Mon
290 | 2010-01-26 00:00:00 | Tue
291 | 2010-01-27 00:00:00 | Wed
292 | 2010-01-28 00:00:00 | Thu
293 | 2010-01-29 00:00:00 | Fri
294 | 2010-01-30 00:00:00 | Sat |  |  |  |  |  | 0 | 0
295 | 2010-01-31 00:00:00 | Sun
296 | 2010-02-01 00:00:00 | Mon
297 | 2010-02-02 00:00:00 | Tue