Matrix to Gantt Chart Visualization

Hello,

I've been searching on the internet for solutions for a few weeks now and I still can't find what I'm looking for.

I required to visualize room utilisation per date based on AM/PM.

I created a time gantt chart using the matrix visualisation by date to show the bed utilisation from the time of admission of patients to time of dischare of admission for each bed. I managed to achieve this easily enough with the below code and conditional formatting.

and turned out to be like this

The problem is cant make more hierarchy to show AM/PM for each date. I'm stucked with that.

I want to visualize it to look something like below:

Hope anyone can help with this.

Thanks.