Creating a timeline from Excel data

Please consider the following Worksheet:

Please Login or Register  to view this content.

I want to represent it visually (chart?) so that there is a time line for all Prod (=X) tasks, that shows overlaps in time.
It can be represented one chart per day to keep it clear.
Since some jobs start late evening and run into the morning, this needs to be shown too.
So for example, Tuesday, Task 5 starts at 8pm and runs for 4 hours until midnight.
This could technically be shown on the single day, but Task 1 runs for 5 hours from 10.30pm to 3.30am so cuts across two days.


Is it possible with Excel without resorting to VBA?

Thanks

Originally Posted by Pepe Le Mokko

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks - I have attached one for your reference.

Timeline has something I visualise the result to be.

I managed to use formula to do this but had some questions relating to references, so solving this and raising in appropriate forum area.

Thanks