Auto populating a calendar based on list

[pauldaddyadams]

Hi,

I am trying to put an agenda spreadsheet together which will populate based on a list.

In cells B10:I35 I have a table which users will populate. Within this list they put in the following:
• Activity Detail
• Work stream
• Owner
• Day
• Start Time
• Duration (minutes)

Based on this list I would like it to populate the 3 day calendar in columns K:O. Can this be achieved?

I know it might be easier to populate the calendar directly but I want to prevent this if I can find a workaround.

Where there is a conflict can this be flagged in anyway? E.g. if there is a time overlap?

And the other problem I have is if I try and add the break minutes (100mins) how do I display this as 1 Hour 40 Mins in the summary table, cell D44