Spreadsheet: 76177d1276716897-saving-monthly-totals-example-sheet
Sheet: Wk2 with data

Week Starting |  | 2010-01-01 00:00:00 |  |  | Weekly Total |  |  |  |  | Monthly Total |  | 560
Date | Start Time | End Time | Amount | Total Time | Date | Start Time | End Time | Amount | Total Time | Date | Start Time | End Time | Amount | Total Time
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-04 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-07 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  |  |  |  | [NAME] somewhere over here
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-02 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-05 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5
2010-01-03 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5 |  | 2010-01-06 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 5