ExcelBanter - Creating an hourly planner from excel data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating an hourly planner from excel data (https://www.excelbanter.com/excel-worksheet-functions/267030-creating-hourly-planner-excel-data.html)

graeme_706

Creating an hourly planner from excel data

2 Attachment(s)

Hi,
I am new to this group, this is my first post. Have have data from a scheduling spreadsheet that I would like to display in an hourly segment form. (actually broken into 15 mins blocks. I have been experimenting with the VLOOKUP function, bet getting now where fast !

Any help or advice most welcome.

See the two attachments for the data and the format I wish to produce (One for each day of the week, shown is just Tues and Wed).

Graeme

All times are GMT +1. The time now is 12:37 PM.