I have a potentially difficult scenario to try and get help with.

I have a list of shift start and end times e.g. 7am - 5pm as well as the number of people working each of these day in a table.

It has days of the week across the top and then each shift pattern listed down the side. I then have a list of 'demand' sorted by hour of the day for each day of the week. I want to list down in columns starting at 00:00 Monday until 23:00 Sunday corresponding numbers of people and demand so that I can match them up. Somehow the shifts need to be converted into a list of hours and matched against the numbers in the table and then the demand needs a similar process!!

I don't even know where to start on this one so any help is greatly appreciated.