Divide the hours by 24 then add that to the start date.

If the hours is 100, 100/24 = 4.166667

How do you want to handle the decimal part of 4.166667 days? Round up to 5?
Round down to 4?


--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
D1 as my start date, ColumnB as my Qty needed, ColumnC as my due date,
ColumnD as my completion date, ColumnF as number of hours it take ColumnB
to
run. I have all the info I need except for the end result in ColumnD the
completion date. Thanks in advance!