Spreadsheet: 86223d1286243066-formula-to-create-roster-hours-worked-in-24-hour-time-with-breaks-roster
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Roster Starts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-15 00:00:00
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Staff | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Hours
[NAME] | MM |  |  |  | 09:00:00 | 16:15:00 | 00:30:00 |  | 10:00:00 | 15:15:00 | 00:00:00 |  | 09:00:00 | 17:45:00 |  |  | RDO |  |  |  | RDO |  |  |  | 09:00:00 | 16:15:00
Nicole | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 16:15:00 | 00:30:00 |  | 10:00:00 | 15:15:00 | 00:00:00 |  |  |  | 00:30:00 |  |  |  | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 16:00:00 | 21:15:00 | 00:30:00
[NAME] | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00
Nikki | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Staff Member | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Hours
[NAME] | MM |  |  |  | MM |  |  |  | MM |  | 00:00:00 |  | MM |  |  |  | MM |  |  |  | MM |  |  |  | MM |  |  |  | 5
Nicole | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00
[NAME] | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 0
Nikki | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Staff on hand
Week 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Staff Member | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Hours
[NAME] | MM |  |  |  | MM |  |  |  | MM |  | 00:00:00 |  | MM |  |  |  | MM |  |  |  | MM |  |  |  | MM |  |  |  | 0
Nicole | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 0
[NAME] | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 0
Nikki | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Staff on hand
Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Staff Member | Friday |  |  |  | Saturday |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Hours
[NAME] | MM |  |  |  | MM |  |  |  | MM |  | 00:00:00 |  | MM |  |  |  | MM |  |  |  | MM |  |  |  | MM |  |  |  | 8.25
Nicole | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 8.25
[NAME] | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 0
Nikki | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:00:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 09:00:00 | 17:45:00 | 00:30:00 |  | 8.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.25
Staff on hand
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00