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

 |  |  | 2013/2014 |  | Period 1 |  |  |  | Period 2 |  |  |  | Period 3 |  |  |  | Period 4 |  |  |  | Period 5 |  |  |  | Period 6 |  |  |  | Period 7 |  |  |  | Period 8 |  |  |  | Period 9 |  |  |  | Period 10 |  |  |  | Period 11 |  |  |  | Period 12 |  |  |  | Period 13
 |  |  |  |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 | Contracted Hours | Department | Entitlement | Booked | 2013-03-17 00:00:00
 | 39 | FRESH FOODS | 234 |  |  |  | 8 |  |  | 39 |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  | 15 | 7 |  | 39 | 9
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wed, thu | wed |  | week | mon
 | 39 | FRESH FOODS | 258 |  |  | 8 | 7.5 |  |  |  |  | 7.5 | 8 | 7.5 | 7.5 |  |  | 39 |  |  |  |  |  |  |  | 39 | 39 | 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 16 | 16.5 |  |  |  |  | 39
 |  |  | [NAME] |  |  | fri | mon |  |  |  |  | mon | fri | mon | mon |  |  | week |  |  |  |  |  |  |  | week | week | mon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w,t | wed,thu | thu, fri |  |  |  |  | week
 | 15 | FRESH FOODS | 116 |  |  | 5 | 15 |  |  |  |  | 5 |  |  | 15 |  |  |  |  |  |  |  |  | 15 | 15 |  |  | 5 |  |  |  |  |  |  | 5 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 6
 |  |  | [NAME] |  |  | fri | week |  |  |  |  | mon |  |  | week |  |  |  |  |  |  |  |  | week | week |  |  | mon |  |  |  |  |  |  | mon |  | week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | week |  | mon
 | 16 | FRESH FOODS | 96 |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  | 16 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 16 | 8
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  | week |  |  |  |  |  |  |  |  | week | week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | week |  |  |  |  | mon |  |  |  |  |  |  |  |  | week | mon
 |  |  | [NAME]
 | 24 | FRESH FOODS | 162 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 24 |  |  |  |  |  |  |  |  | 24 | 24 |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 8 | 8 | 10 |  |  |  |  |  | 8 |  |  | 24
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sat | week |  |  |  |  |  |  |  |  | week | week |  |  |  |  | week |  |  |  |  |  |  |  |  |  | thu | sat | sat |  |  |  |  |  | sat |  |  | week
 | 20 | FRESH FOODS | 74 |  |  |  |  |  |  | 20 | 20 |  |  | 6 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 6 | 6
 |  |  | [NAME] |  |  |  |  |  |  | week | week |  |  | sat | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mon |  |  |  | sat | [NAME]
 | 39 | FRESH FOODS | 258 |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  | 39 | 31 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 15 |  |  |  |  | 39 |  |  | 39 |  | 39
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | week |  |  |  |  |  |  |  |  | week | week |  | sat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wed | [NAME] |  |  |  |  | week |  |  | week |  | week
 | 12 | FRESH FOODS | 83 |  |  |  | 4 | 7 |  |  |  | 8 | 4 |  |  |  |  |  | 8 | 12 | 4 |  |  |  | 8 | 4 |  |  |  |  |  |  |  |  |  |  | 8 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4
 |  |  | [NAME] |  |  |  | [NAME] | sat |  |  |  | sat | [NAME] |  |  |  |  |  | sat | week | [NAME] |  |  |  | sat | [NAME] |  |  |  |  |  |  |  |  |  |  | sat | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sat | [NAME]
 | 18 | FRESH FOODS | 108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 18 |  |  |  |  |  |  |  |  |  |  |  | 18 | 18 |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | week | week |  |  |  |  |  |  |  |  |  |  |  | week | week |  |  |  |  |  |  | week |  |  |  |  |  |  |  |  |  |  |  |  | week
 | 16 | FRESH FOODS | 96 |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  | 8 | 16 | 4
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | wed thur | wed thur
 |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 12 |  |  |  | 4 | 12 |  |  |  |  |  |  |  |  |  | 4 |  | 2 | 12
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], tue
 |  |  | 50
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
[NAME] | 39 | MANAGERS | 258 |  |  |  |  | 39 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  | 8 | 8 |  |  |  | 39 |  |  |  |  | 39
 |  |  | [NAME] |  |  |  |  | week |  |  |  |  | week |  |  |  |  |  |  |  |  |  |  |  | week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | week |  |  |  | thu | wed |  |  |  | week |  |  |  |  | week
% Booked |  | Total entitlement
 |  | Total booked |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Note: |  | [NAME] |  |  | Budget |  | 66 |  | Budget |  | 70 |  | Budget |  | 91 |  | Budget |  | 95 |  | Budget |  | 103 |  | Budget |  | 121 |  | Budget |  | 97 |  | Budget |  | 83 |  | Budget |  | 86 |  | Budget |  | 52 |  | Budget |  | 114 |  | Budget |  | 106 |  | Budget |  | 116
In the [NAME] that make up entitlement and book D29 & E29 are missing due to not adding in the Managers |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  | Manager Minus |  |  |  |  | 39 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  | 8 | 8 |  |  |  |  |  |  |  |  | 39
Contract Hours=
 |  |  | open
 |  |  | closed