How to show overlapping times on a schedule

Here is my workbook. No sensitive data supplied, so not too worried about that. The 1st sheet is where the schedule is input. The 2nd takes the data from the 1st to show a printable version. The 3-9th sheets are the charts.

Thanks,

Dan