Spreadsheet: 132701d1323884344-using-excel-to-calculate-hours-worked-master
Sheet: Team Formulas

 |  |  | Week 1 |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5 |  |  |  | Week 6 |  |  |  | Week 7 |  |  |  | Week 8 |  |  |  | Week 9 |  |  |  | Week 10 |  |  |  | Week 11 |  |  |  | Week 12 |  |  |  | Week 13 |  |  |  | Week 14 |  |  |  | Week 15 |  |  |  | Week 16 |  |  |  | Week 17 |  |  |  | Week 18
 |  |  | By Individual | By Individual | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team | By Individual | By Individual | By Team | By Team
1 | 2 | 3 | Total Hours Worked | % Hours Worked | % Hours Worked | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked Ongoing (2) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (3) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (4) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (6) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (7) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (8) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (9) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (10) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (11) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (12) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (13) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (14) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (15) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (16) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (17) | Total Hours Worked | % Hours Worked | % Hours Worked | % Hours Worked - Ongoing (18)
4 | 5 | 6
Team | Name | ID | 2012-01-02 00:00:00 | through | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | through |  | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | through |  | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | through |  | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | through |  | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | through |  | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 | through |  | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | through |  | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | through |  | 2012-03-04 00:00:00 | 2012-03-05 00:00:00 | through |  | 2012-03-11 00:00:00 | 2012-03-12 00:00:00 | through |  | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | through |  | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | through |  | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | through |  | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | through |  | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | through |  | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | through |  | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 | through |  | 2012-05-06 00:00:00
5 | A | 5630
5 | B | 5208
1 | C | 5610
6 | D | 5904