Gantt chart with daily repeated tasks spanning midnight

Hi, I have some issues creating a gantt chart (stacked bar).

There's plenty of information about Gantt charts in general but not on these topics:

- repeating different daily tasks
- tasks that span midnight

So I'm stuck with the following:
-Creating horiz. axis from 18h to 18h (instead of 00:00 to 00:00)
-Crossing midnight (start one day and end the next)
-Continuing task from one row to the next
-Formatting the different tasks and creating the legend

Does it have something to do with making different data series per tasks? Maybe the data needs to be put in a pivot table? I can't seem to make this work.

Any suggestions would be greatly appreciated, I have a rather big data set to visualise here...