Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate end date and time
I am working on a trip planning worksheet for my spouse to use.
I have the sheet set up to take the following A1 = Miles from previous A2 = Miles loaded A3 = Previous Hours A4 = Hours needed [formula = (a1+a2)/50+a3] A5 = DOT breaks needed [formula = a4/11] A6 = total hours to complete [formula = (c5*10)+c4] B4 = (a1+a2)/50+a3 B5 = a4/11 C4 = roundup(b4,0) C5 = rounddown(b5,0) I would like to take the result of A6 and calculate a end date and time based on a manually entered start date and time. Any advice on a formula that will accomplish this? Thanks in advance! Last edited by chciknwing : February 2nd 14 at 01:55 AM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate end date and time
On Sun, 2 Feb 2014 01:50:37 +0000, chciknwing wrote:
I am working on a trip planning worksheet for my spouse to use. I have the sheet set up to take the following A1 = Miles from previous A2 = Miles loaded A3 = Previous Hours A4 = Hours needed [formula = (a1+a2)/50+a3] A5 = DOT breaks needed [formula = a4/11] A6 = total hours to complete [formula = (c5*10)+c4] B4 = (a1+a2)/50+a3 B5 = a4/11 C4 = roundup(b4,0) C5 = rounddown(b5,0) I would like to take the result of A6 and calculate a end date and time based on a manually entered start date and time. Any advice on a formula that will accomplish this? Thanks in advance! Excel stores time as days and fractions of a day. So if A6 units is a decimal number representing the hours, divide it by 24 and add it to the manuallay entered date and time. e.g: B1: 2/15/2014 8 AM End date: =B1+A6/24 Format as m/d/yyyy h:mm AM/PM (or however you want) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate within a time range with only start date and end date | Excel Worksheet Functions | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
How to calculate the MTBF for time and date. | Excel Programming | |||
How to calculate date and time | Excel Discussion (Misc queries) |