Hi Scaffold
Your solution is attached.
Basically Excel stores dates as the number of days since 1st January 1900. On that basis, as you have stored your individual task duration's as percentages of a day you just need to add the start date to the number of days for your first task to get the completion date of Task 1. Then for task 2 add the start date to the duration's of Task 1 and Task 2 and so on.
To obtain the end date of all the tasks simply add the start date to all the duration's of each task.
Hope this helps.
Tony(OTPM)
|