Need help with a formula for scheduling based on duration and priority of events

Hi dear Excel gurus!

I have a an issues coming up with a formula to create a schedule based on a given input.

Please find attached a spreadsheet outlining the problem with given scenarios and desired OUTPUT.

Scenario 1 = output schedule 1 (with emphasis on high priority events)
Scenario 2 = output schedule 2 (with emphasis on evenly spacing out high and normal priority events)

I am not quite familiar with functionality of Excel and wonder if any array formula would do the job. I have seen people do magic here with Excel and thought to give it a try.

Always eager to learn new things

Thanks in advance! Any help/idea will save the day!

-T