Spreadsheet: 91052d1290728964-creating-a-15-minute-planner-desired-outcome
Sheet: Desired Outcome

Date | Time | StartTime | Duration (hr) | EndTime | CarerFirstname | Details
2010-11-23 00:00:00 | 09:00:00 | 2010-11-23 09:00:00 | 1 | 2010-11-23 10:00:00 | [NAME] | Visit MrL
2010-11-23 00:00:00 | 12:00:00 | 2010-11-23 12:00:00 | 1 | 2010-11-23 13:00:00 | [NAME] | Visit MrsD
2010-11-23 00:00:00 | 22:00:00 | 2010-11-23 22:00:00 | 0.5 | 2010-11-23 22:30:00 | [NAME] | Visit MrL
2010-11-24 00:00:00 | 09:00:00 | 2010-11-24 09:00:00 | 1 | 2010-11-24 10:00:00 | [NAME] | Visit MrsF
2010-11-24 00:00:00 | 09:00:00 | 2010-11-24 09:00:00 | 1 | 2010-11-24 10:00:00 | [NAME] | Visit MrL
2010-11-24 00:00:00 | 10:30:00 | 2010-11-24 10:30:00 | 1 | 2010-11-24 11:30:00 | [NAME] | Visit MrK
2010-11-24 00:00:00 | 12:00:00 | 2010-11-24 12:00:00 | 1 | 2010-11-24 13:00:00 | [NAME] | Visit MrsD
2010-11-24 00:00:00 | 14:00:00 | 2010-11-24 14:00:00 | 2 | 2010-11-24 16:00:00 | [NAME] | Visit MrsB
2010-11-24 00:00:00 | 22:00:00 | 2010-11-24 22:00:00 | 0.5 | 2010-11-24 22:30:00 | [NAME] | Visit MrL
2010-11-25 00:00:00 | 09:00:00 | 2010-11-25 09:00:00 | 1 | 2010-11-25 10:00:00 | [NAME] | Visit MrL
2010-11-25 00:00:00 | 10:00:00 | 2010-11-25 10:00:00 | 2 | 2010-11-25 12:00:00 | [NAME] | Visit MrK
2010-11-25 00:00:00 | 12:00:00 | 2010-11-25 12:00:00 | 1 | 2010-11-25 13:00:00 | [NAME] | Visit MrsD
2010-11-25 00:00:00 | 13:30:00 | 2010-11-25 13:30:00 | 2 | 2010-11-25 15:30:00 | [NAME] | Visit MrsF
2010-11-25 00:00:00 | 14:00:00 | 2010-11-25 14:00:00 | 1 | 2010-11-25 15:00:00 | [NAME] | Visit MissW
2010-11-25 00:00:00 | 21:30:00 | 2010-11-25 21:30:00 | 0.5 | 2010-11-25 22:00:00 | [NAME] | Visit MrL
2010-11-26 00:00:00 | 09:00:00 | 2010-11-26 09:00:00 | 1 | 2010-11-26 10:00:00 | [NAME] | Visit MrL
2010-11-26 00:00:00 | 09:00:00 | 2010-11-26 09:00:00 | 1 | 2010-11-26 10:00:00 | [NAME] | Visit MrsF
2010-11-26 00:00:00 | 12:00:00 | 2010-11-26 12:00:00 | 1 | 2010-11-26 13:00:00 | [NAME] | Visit MrsD
2010-11-26 00:00:00 | 21:30:00 | 2010-11-26 21:30:00 | 0.5 | 2010-11-26 22:00:00 | [NAME] | Visit MrL
 |  |  |  |  |  |  |  | 2010-11-23 00:00:00 | Tuesday
 |  |  |  |  |  |  |  |  | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Visit MrL |  |  |  |  |  |  |  |  |  |  |  | Visit MrsD
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visit MrL
 |  |  |  |  |  |  |  | 2010-11-24 00:00:00 | Wednesday
 |  |  |  |  |  |  |  |  | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Visit MrsF |  |  |  |  |  | Visit MrK |  |  |  |  |  | Visit MrsD
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Visit MrL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visit MrsB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Visit MrL
 |  |  |  |  |  |  |  | Carry on Wednesday to Sunday