I need to find the Finish Date & Time of a task if I am giving the following
- Activity Duration ( Hrs) and
- The Start Date & Time.
The Finish Date & Time should exclude Non working Days ( Sat &Sun) as well as Non - working time ( working time is 8:30 to 5:30)
Also need to find the Actual Duration (Hours) if I am giving the Actual Finish Date & Time.
The following is the format i am Planning:
Duration (Hours)(1) Start Date &Time (2) Expected Finish Date &Time (3)=1+2) Actual Finish Date & Time(4) Actual Duration (Hours)(5)=4-2)
Thanks in advance for all the help