Ok i have tried a lot of the excel and open office demonstration/turorials etc etc.
I just give up.

Posting a pic of a graph that id like to make and hoping this forum can help.

Basically i want to visual time based weekly roster. Where in the eg i have 3 diff workers represented by diff colors. Left side of the graph shows the times they work (eg 7.30am-8pm) bars are plotted on the graph by default of 7am(minimum) - 9pm(maximum). So the start(7.30am) finish(8pm) time in conjuction with whatever day and the graph just fills itself in.