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!

time is in days so you must convert hours to days by dividing by 24.

for data in row 5
Cell D5
=(F5/24)+D1

Make sure the format for column D is a date format. Copy formula down
column D.

"Richard" wrote:

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!

Richard,

Column F is the number of hours it takes for each unit to run, or for the
number of units in Qty Needed to run?

Is the number of hours in decimal format (35.5 hours) or an XL time format
(35:30)?

How about number of work/processing/manufacturing hours in a day? ...8?
....10? ...24?

Assuming data starts in row 4, Number of Hours is the time for Qty Needed,
Number of hours in decimal format, 24 working hours per day:
Enter this formula in D4:
=$D$1+(B4/24)

HTH,

Conan





"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!

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!