Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting €“ Due Date, Warning - Completion | Excel Discussion (Misc queries) | |||
Conditional Formatting €“ Due Date, Warning - Completion | Excel Discussion (Misc queries) | |||
Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
Completion Percentage of a date range | Excel Discussion (Misc queries) | |||
Estimated date of completion | Excel Worksheet Functions |