LinkBack URL
About LinkBacks
Please consider the following Worksheet:
I want to represent it visually (chart?) so that there is a time line for all Prod (=X) tasks, that shows overlaps in time.
Task Prod Dev Mon Tue Wed Thu Fri Sat Sun Scheduled_start_time Approx_duration Est_end_time Task_1 X X X X 22:30 05:00 00:30 Task_2 X X X X X X X 00:05 01:00 01:05 Task_3 X X X 07:00 00:05 07:05 Task_3 X X X 07:15 00:05 07:20 Task_3 X X X 07:30 00:05 07:35 Task_3 X X X 07:45 00:05 07:50 Task_3 X X X 08:00 00:05 08:05 Task_3 X X X 08:15 00:05 08:20 Task_3 X X X 08:30 00:05 08:35 Task_3 X X X 08:45 00:05 08:50 Task_3 X X X 09:00 00:05 09:05 Task_3 X X X 09:15 00:05 09:20 Task_3 X X X 09:30 00:05 09:35 Task_3 X X X 09:45 00:05 09:50 Task_3 X X X 10:00 00:05 10:05 Task_3 X X X 10:15 00:05 10:20 Task_3 X X X 10:30 00:05 10:35 Task_3 X X X 10:45 00:05 10:50 Task_3 X X X 17:00 00:05 17:05 Task_3 X X X 17:15 00:05 17:20 Task_3 X X X 17:30 00:05 17:35 Task_3 X X X 17:45 00:05 17:50 Task_4 X X X X X X 20:00 04:00 00:00 Task_5 X X X X X X 20:00 04:00 00:00 Task_6 X X X 14:00 00:30 14:30 Task_6 X X X 15:00 00:30 15:30 Task_6 X X X 16:00 00:30 16:30 Task_6 X X X 17:00 00:30 17:30 Task_7 X X X X X X X X X 18:00 01:30 19:30
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
Register To Reply
Bookmarks