Hi

The returns the same answer as Bob but uses the 19 hour factor

=A1+SUM(B2:B6)/24*19

Where the start date is in A1 and the days are in B2:B6.

To handle holidays you will need to modify the approach:

=C3-NETWORKDAYS(A1,C3,M1:M5)+NETWORKDAYS(A1,C3)

In this case the first formula is in C3 and you would enter Holidays in M1:M5

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Cam" wrote:

Hello,

I am trying to find a formula to calculation the estimated completion date
for different operations which returns the date excluding holiday working 7
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
30 0.667
40 1.611
50 0.667

Thank for sugguestions