This gives you the result you posted

=WORKDAY($A$1,INT(B3))+MOD(B3,1)

but I don't get why it is 01:04 AM and not 07:04 AM.

How does 19 hours factor in, what are the 5 non-working hours?

--
__________________________________
HTH

Bob

"Cam" wrote in message
...
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