Spreadsheet: 293152d1390910266-separating-dates-into-weeks-sample-20data-1-
Sheet: Sheet1

 | Completed Date | Completed Time | Submitted Date | Submitted Time | Eng Time | Team Time |  |  |  | Week no | count | [NAME] | Team Avr | [NAME] | Team Avr
 | 2013-10-02 00:00:00 | 03:26:00 | 2013-09-30 00:00:00 | 04:21:00 | 28.48333333345363 | 47.08333333331393 |  |  |  | 40 |  | 23.97600000000559 | 142.212666666673
 | 2013-10-03 00:00:00 | 01:10:00 | 2013-09-30 00:00:00 | 08:43:00 | 41.23333333327901 | 64.45000000001164 |  |  |  | 41 |  | 60.36 | 109.0909722222204
 | 2013-10-01 00:00:00 | 07:33:00 | 2013-09-30 00:00:00 | 20:44:00 | 6.683333333465271 | 10.81666666665114
 | 2013-10-01 00:00:00 | 08:10:00 | 2013-10-01 00:00:00 | 01:59:00 | 6 | 6.183333333407063
 | 2013-10-02 00:00:00 | 02:37:00 | 2013-10-01 00:00:00 | 08:35:00 | 5.650000000081491 | 18.03333333326736
 | 2013-10-02 00:00:00 | 08:04:00 | 2013-10-02 00:00:00 | 00:10:00 | 4.266666666604578 | 7.899999999906868
 | 2013-10-02 00:00:00 | 08:03:00 | 2013-10-02 00:00:00 | 03:39:00 | 1.483333333279006 | 4.400000000023283
 | 2013-10-03 00:00:00 | 01:58:00 | 2013-10-02 00:00:00 | 08:20:00 | 0.1333333334187046 | 17.6333333333605
 | 2013-10-03 00:00:00 | 08:55:00 | 2013-10-02 00:00:00 | 14:29:00 | 14.83333333348855 | 18.43333333334886
 | 2013-10-03 00:00:00 | 07:21:00 | 2013-10-02 00:00:00 | 16:32:00 | 12.94999999995343 | 14.81666666676756
 | 2013-10-03 00:00:00 | 10:23:00 | 2013-10-02 00:00:00 | 20:34:00 | 12.03333333326736 | 13.81666666665114
 | 2013-10-03 00:00:00 | 10:13:00 | 2013-10-03 00:00:00 | 04:28:00 | 4.233333333337214 | 5.749999999883585
 | 2013-10-04 00:00:00 | 06:15:00 | 2013-10-03 00:00:00 | 17:03:00 | 10.45000000001164 | 13.19999999989523
 | 2013-10-07 00:00:00 | 05:43:00 | 2013-10-03 00:00:00 | 22:14:00 | 78.23333333339542 | 79.483333333279
 | 2013-10-06 00:00:00 | 03:12:00 | 2013-10-03 00:00:00 | 23:40:00 | 6.999999999941792 | 51.53333333332557
 | 2013-10-06 00:00:00 | 03:11:00 | 2013-10-03 00:00:00 | 23:41:00 | 6.983333333220799 | 51.50000000005821
 | 2013-11-07 00:00:00 | 04:25:00 | 2013-10-03 00:00:00 | 23:44:00 | 7.950000000069849 | 820.6833333334071
 | 2013-11-07 00:00:00 | 04:27:00 | 2013-10-04 00:00:00 | 00:21:00 | 7.39999999984866 | 820.1000000000931
 | 2013-10-04 00:00:00 | 06:28:00 | 2013-10-04 00:00:00 | 04:47:00 | 0.03333333326736465 | 1.68333333323244
 | 2013-10-04 00:00:00 | 06:27:00 | 2013-10-04 00:00:00 | 04:55:00 | 0.01666666672099382 | 1.533333333441988
 | 2013-10-08 00:00:00 | 02:16:00 | 2013-10-04 00:00:00 | 06:17:00 | 73.58333333325572 | 91.98333333333721
 | 2013-10-06 00:00:00 | 03:08:00 | 2013-10-04 00:00:00 | 06:52:00 | 0.1833333332324401 | 44.26666666672099
 | 2013-10-22 00:00:00 | 21:42:00 | 2013-10-05 00:00:00 | 04:48:00 | 239.8500000000349 | 424.9000000000815
 | 2013-10-07 00:00:00 | 05:40:00 | 2013-10-06 00:00:00 | 05:30:00 | 23.33333333343035 | 24.16666666668607
 | 2013-11-12 00:00:00 | 18:45:00 | 2013-10-06 00:00:00 | 05:47:00 | 6.400000000081491 | 900.9666666666744
 |  |  |  | AVERAGE | 23.97600000000559 | 142.212666666673
 | Completed Date | Completed Time | Submitted Date | Submitted Time | Eng Time | Team Time
 | 2013-10-08 00:00:00 | 04:43:00 | 2013-10-07 00:00:00 | 02:57:00 | 5.25 | 25.76666666666279
 | 2013-10-13 00:00:00 | 02:58:00 | 2013-10-07 00:00:00 | 03:01:00 | 0.3333333333721384 | 143.9500000000116
 | 2013-10-08 00:00:00 | 02:13:00 | 2013-10-07 00:00:00 | 04:46:00 | 6.016666666720994 | 21.45000000006985
 | 2013-10-08 00:00:00 | 02:11:00 | 2013-10-07 00:00:00 | 08:33:00 | 0.01666666672099382 | 17.6333333333605
 | 2013-10-08 00:00:00 | 02:10:00 | 2013-10-07 00:00:00 | 08:38:00 | 0 | 17.53333333338378
 | 2013-10-10 00:00:00 | 04:51:00 | 2013-10-07 00:00:00 | 15:54:00 | 40.96666666661622 | 60.94999999995343
 | 2013-10-11 00:00:00 | 02:55:00 | 2013-10-07 00:00:00 | 16:08:00 | 66.58333333331393 | 82.78333333338378
 | 2013-10-08 00:00:00 | 04:26:00 | 2013-10-07 00:00:00 | 18:09:00 | 9.066666666709352 | 10.28333333332557
 | 2013-10-22 00:00:00 | 22:10:00 | 2013-10-07 00:00:00 | 19:42:00 | 345.0833333334303 | 362.4666666666744
 | 2013-10-09 00:00:00 | 04:01:00 | 2013-10-08 00:00:00 | 05:39:00 | 5.43333333323244 | 22.3666666665813
 | 2013-10-08 00:00:00 | 07:21:00 | 2013-10-08 00:00:00 | 06:17:00 | 0.04999999998835847 | 1.066666666651145
 | 2013-10-13 00:00:00 | 02:48:00 | 2013-10-09 00:00:00 | 00:50:00 | 31.8833333333605 | 97.96666666679084
 | 2013-10-14 00:00:00 | 09:12:00 | 2013-10-09 00:00:00 | 07:46:00 | 118.483333333279 | 121.4333333332906
 | 2013-10-10 00:00:00 | 10:57:00 | 2013-10-09 00:00:00 | 16:33:00 | 16.91666666662786 | 18.40000000008149
 | 2013-10-13 00:00:00 | 02:51:00 | 2013-10-10 00:00:00 | 07:25:00 | 24.60000000003492 | 67.43333333329065
 | 2013-10-22 00:00:00 | 21:46:00 | 2013-10-10 00:00:00 | 11:05:00 | 281.5499999999302 | 298.6833333334071
 | 2013-10-22 00:00:00 | 22:52:00 | 2013-10-10 00:00:00 | 11:26:00 | 281.5833333333721 | 299.4333333332324
 | 2013-10-11 00:00:00 | 02:53:00 | 2013-10-10 00:00:00 | 12:16:00 | 14.3833333334187 | 14.6166666666395
 | 2013-10-22 00:00:00 | 04:04:00 | 2013-10-10 00:00:00 | 14:55:00 | 12.91666666668607 | 277.1499999999069
 | 2013-10-22 00:00:00 | 04:03:00 | 2013-10-10 00:00:00 | 16:50:00 | 12.2333333332208 | 275.216666666558
 | 2013-10-14 00:00:00 | 08:21:00 | 2013-10-11 00:00:00 | 03:22:00 | 76.31666666676756 | 76.98333333333721
 | 2013-10-14 00:00:00 | 04:21:00 | 2013-10-11 00:00:00 | 04:27:00 | 71.31666666670935 | 71.90000000002328
 | 2013-10-11 00:00:00 | 06:34:00 | 2013-10-11 00:00:00 | 05:01:00 | 0.9666666664998047 | 1.549999999988358
 | 2013-10-22 00:00:00 | 23:03:00 | 2013-10-13 00:00:00 | 07:53:00 | 26.73333333333721 | 231.1666666666861
 |  |  |  |  | 60.3618055555562 | 109.0909722222204