Spreadsheet: 885670d1735480166-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-2-spill-365-aligw
Sheet: WeeklyShiftTemplate

 |  |  |  |  | 1900-01-01 00:00:00 |  |  |  | 1900-01-02 00:00:00 |  |  |  |  |  | 1900-01-03 00:00:00 |  |  |  |  | 1900-01-04 00:00:00 |  |  |  |  | 1900-01-05 00:00:00 |  |  |  |  | 1900-01-06 00:00:00 |  |  |  |  | 1900-01-07 00:00:00
 |  |  |  |  | Monday |  |  |  | Tuesday |  |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday |  |  |  |  | Saturday |  |  |  |  | Sunday
CODE | Week Template |  |  | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish
WDN | WEEKDAY NIGHTS |  |  | Night | 21:30:00 | 07:30:00 |  |  | Night | 21:30:00 | 07:30:00 |  |  | Night | 21:30:00 | 07:30:00 |  |  | Night | 21:30:00 | 07:30:00
WEN | WEEKEND NIGHTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night (Early Start) | 20:00:00 | 08:30:00 |  |  | Night (Early Start) | 20:00:00 | 08:30:00 |  |  | Night (Early Start) | 20:00:00 | 08:30:00
WEE | WEEKEND EVENING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00 | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00 | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00
WDE1 | WEEKDAY EVENING |  |  | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00 | Evening | 12:00:00 | 22:00:00 |  |  | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00 | Evening | 12:00:00 | 22:00:00
WDE2 | WEEKDAY EVENING 2 |  |  | Evening | 12:00:00 | 22:00:00 |  |  | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00 | Evening | 12:00:00 | 22:00:00 |  |  | Evening | 12:00:00 | 22:00:00 | 22:00:00 | 07:30:00
WED10 | WEEKEND DAYS 10 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00
WED12 | WEEKEND DAYS 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day (12H) | 08:00:00 | 20:30:00 |  |  | Day (12H) | 08:00:00 | 20:30:00 |  |  | Day (12H) | 08:00:00 | 20:30:00
DaysM | DAYS (Mon Off) |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00
DaysTu | DAYS (Tue Off) |  |  | Day | 07:30:00 | 17:30:00 |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00
DaysW | DAYS (Wed Off) |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00
[NAME] | DAYS (Thu Off) |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00
DaysF | DAYS (Fri Off) |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00
WD3 | [NAME] (after hrs cover) |  |  | Day | 07:30:00 | 17:30:00 | 17:30:00 | 07:30:00 | Day | 07:30:00 | 17:30:00 | 17:30:00 | 07:30:00 | Day | 07:30:00 | 17:30:00 | 17:30:00 | 07:30:00 | Day | 07:30:00 | 17:30:00 | 17:30:00 | 07:30:00
WE3 | WE3rd (after hrs cover) |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 | 17:30:00 | 07:30:00 |  |  |  | 07:30:00 | 07:30:00 |  |  |  | 07:30:00 | 07:30:00
WEP | [NAME] |  |  | Day | 07:30:00 | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00 |  |  | Day | 07:30:00 | 17:30:00
LEAVE | RLEAVE
CARDIAC1 | CARDIAC Week 1 |  |  | Early 12H | 07:00:00 | 19:30:00 |  |  | Early 12H | 07:00:00 | 19:30:00 |  |  |  |  |  |  |  | Early 12H | 07:00:00 | 19:30:00
[NAME] | CARDIAC Week 2 |  |  | Morning | 08:00:00 | 12:00:00 |  |  | Early 12H | 07:00:00 | 19:30:00 |  |  |  |  |  |  |  | Early 12H | 07:00:00 | 19:30:00 |  |  | Early 12H | 07:00:00 | 19:30:00