Interval column chart for tasks spanning across hours.

Hi everyone, can anybody helps me about this exercise:

I'd like to create a column chart where the Y-axis values represent the starting times of tasks in hourly format, and the X-axis represents the intervals between these two times. In cases where the ending times do not align perfectly with intervals, the chart should recognize that, for instance, the task lasted 1 hour from 7 to 8 and another hour from 8 to 9.

And the chart should somehow look like this, with the data structured in this way.