C
Cam
Hello,
I am trying to find a formula to calculation the estimated completion date
for different operations which returns the date excluding holiday working 5
days a week @ 19 hours per day, but couldn't seemed to find the answer how.
Column A1 is the startdate.
Column B is the production time in days required to completed.
Column C starting C3 is the calculated value of completion date in date time
format.
Here is the sample table:
A B C
1/2/2009 6:00 AM StartDate
Opr ProdTime (#Days) ComplDate
10 2.045 1/6/09 1:04 AM
20 0.143 1/6/09 3:15 AM
30 0.667 "
40 1.611 "
50 0.667
Thank for sugguestions
I am trying to find a formula to calculation the estimated completion date
for different operations which returns the date excluding holiday working 5
days a week @ 19 hours per day, but couldn't seemed to find the answer how.
Column A1 is the startdate.
Column B is the production time in days required to completed.
Column C starting C3 is the calculated value of completion date in date time
format.
Here is the sample table:
A B C
1/2/2009 6:00 AM StartDate
Opr ProdTime (#Days) ComplDate
10 2.045 1/6/09 1:04 AM
20 0.143 1/6/09 3:15 AM
30 0.667 "
40 1.611 "
50 0.667
Thank for sugguestions