Please can you help me with this final question on task times and networkdays, I need to work out the Min Finish date of a task and the max start date time which is subject to the finish date:
So example
Task Time 08:00
Min Start Date 01/08/2008 09:00
Min Finish Date (Need to calculate) = Min Start Date + Task Time (assume 7 Hour Day starts at 9 Finishes at 5 with hour for lunch 12-1 and exclude weekends) ie should =4/8/2008 10:00 (cause of weekend)
Finish Date 05/08/2008 15:00
Max Start Date (need to calculate) =Finish Date -Task Time(assume 7 hour day starts at 9 Finishes at 5 with hour for lunch 12-1 & exclude weekends) ie 2/8/2008 14:00
Thanks again!
Bookmarks