Spreadsheet: 298318d1392757413-need-total-sum-of-hours-for-each-shift-assigned-to-each-day-with-no-breaks-help
Sheet: Setup

 |  |  |  |  |  | Colleague Name Input
 | FRESH FOODS |  |  |  |  | [NAME]
 | PRODUCE
 | BAKERY
 | HR |  |  |  |  | [NAME]
 | MANAGERS |  |  |  |  | [NAME]
 | DRY GOODS |  |  |  |  | pete
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 |  |  |  |  |  | 15
 |  |  |  |  |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18
 |  |  |  |  |  | 19
 |  |  |  |  |  | 20
 |  | Prev | This | -1 | -2 | -3 | -4 | Allocated | Period | Week | Sched Week
1 |  |  |  |  |  |  |  | 181 | 1 | 1 | 1 | 01:00:00 |  | 00:30:00
2 |  |  |  |  |  |  |  | 181 | 1 | 2 | 2 | 01:30:00 |  | 01:00:00
3 |  |  |  |  |  |  |  | 181 | 1 | 3 | 1 | 02:00:00 |  | 01:30:00
4 |  |  |  |  |  |  |  | 181 | 1 | 4 | 2 | 02:30:00 |  | 02:00:00
1 |  |  |  |  |  |  |  | 5 | 2 | 1 | 1 | 03:00:00 |  | 02:30:00
2 |  |  |  |  |  |  |  | 6 | 2 | 2 | 2 | 03:30:00 |  | 03:00:00
3 |  |  |  |  |  |  |  | 7 | 2 | 3 | 1 | 04:00:00 |  | 03:30:00
4 |  |  |  |  |  |  |  | 8 | 2 | 4 | 2 | 04:30:00 |  | 04:00:00
1 |  |  |  |  |  |  |  | 9 | 3 | 1 | 1 | 05:00:00 |  | 04:30:00
2 |  |  |  |  |  |  |  | 10 | 3 | 2 | 2 | 05:30:00 |  | 05:00:00
3 |  |  |  |  |  |  |  | 11 | 3 | 3 | 1 | 06:00:00 |  | 05:30:00
4 |  |  |  |  |  |  |  | 12 | 3 | 4 | 2 | 06:30:00 |  | 06:00:00
1 |  |  |  |  |  |  |  | 13 | 4 | 1 | 1 | 07:00:00
2 |  |  |  |  |  |  |  | 14 | 4 | 2 | 2 | 07:30:00
3 |  |  |  |  |  |  |  | 15 | 4 | 3 | 1 | 08:00:00
4 |  |  |  |  |  |  |  | 16 | 4 | 4 | 2 | 08:30:00
1 |  |  |  |  |  |  |  | 17 | 5 | 1 | 1 | 09:00:00
2 |  |  |  |  |  |  |  | 18 | 5 | 2 | 2 | 09:30:00
3 |  |  |  |  |  |  |  | 19 | 5 | 3 | 1 | 10:00:00
4 |  |  |  |  |  |  |  | 20 | 5 | 4 | 2 | 10:30:00
1 |  |  |  |  |  |  |  | 21 | 6 | 1 | 1 | 11:00:00
2 |  |  |  |  |  |  |  | 22 | 6 | 2 | 2 | 11:30:00
3 |  |  |  |  |  |  |  | 23 | 6 | 3 | 1 | 12:00:00
4 |  |  |  |  |  |  |  | 24 | 6 | 4 | 2 | 12:30:00
1 |  |  |  |  |  |  |  | 25 | 7 | 1 | 1 | 13:00:00
2 |  |  |  |  |  |  |  | 26 | 7 | 2 | 2 | 13:30:00
3 |  |  |  |  |  |  |  | 27 | 7 | 3 | 1 | 14:00:00
4 |  |  |  |  |  |  |  | 28 | 7 | 4 | 2 | 14:30:00
1 |  |  |  |  |  |  |  | 29 | 8 | 1 | 1 | 15:00:00
2 |  |  |  |  |  |  |  | 30 | 8 | 2 | 2 | 15:30:00
3 |  |  |  |  |  |  |  | 31 | 8 | 3 | 1 | 16:00:00
4 |  |  |  |  |  |  |  | 32 | 8 | 4 | 2 | 16:30:00
1 |  |  |  |  |  |  |  | 33 | 9 | 1 | 1 | 17:00:00
2 |  |  |  |  |  |  |  | 34 | 9 | 2 | 2 | 17:30:00
3 |  |  |  |  |  |  |  | 35 | 9 | 3 | 1 | 18:00:00
4 |  |  |  |  |  |  |  | 36 | 9 | 4 | 2 | 18:30:00
1 |  |  |  |  |  |  |  | 37 | 10 | 1 | 1 | 19:00:00
2 |  |  |  |  |  |  |  | 38 | 10 | 2 | 2 | 19:30:00
3 |  |  |  |  |  |  |  | 39 | 10 | 3 | 1 | 20:00:00
4 |  |  |  |  |  |  |  | 40 | 10 | 4 | 2 | 20:30:00
1 |  |  |  |  |  |  |  | 41 | 11 | 1 | 1 | 21:00:00
2 |  |  |  |  |  |  |  | 42 | 11 | 2 | 2 | 21:30:00
3 |  |  |  |  |  |  |  | 43 | 11 | 3 | 1 | 22:00:00
4 |  |  |  |  |  |  |  | 44 | 11 | 4 | 2 | 22:30:00
1 |  |  |  |  |  |  |  | 45 | 12 | 1 | 1 | 23:00:00
2 |  |  |  |  |  |  |  | 46 | 12 | 2 | 2 | 23:30:00
3 |  |  |  |  |  |  |  | 47 | 12 | 3 | 1
4 |  |  |  |  |  |  |  | 48 | 12 | 4 | 2
1 |  |  |  |  |  |  |  | 49 | 13 | 1 | 1
2 |  |  |  |  |  |  |  | 50 | 13 | 2 | 2
3 |  |  |  |  |  |  |  | 51 | 13 | 3 | 1
4 |  |  |  |  |  |  |  | 52 | 13 | 4 | 2
 |  | Prev | this | -1 | -2 | -3 | -4