Gantt chart (Stacked Bar)

Hi all, ive been trying to make a chart with no luck.

The chart should show the y axis with the list off staff members and the x axis the time from 6am to 2 am. Ive made a small chart for the data of staff names, shift start time and then the duration in hours. Start times formatted to time (eg 06:30) however im not sure how to format the duration. The x axis also keeps showing time through multiple days, and the data for duration seems to stretch too far than a few hours.

Any help is welcome, im not well experienced in excel so i apologise