Calculate end date and time

[chciknwing]

I am working on a trip planning worksheet for my spouse to use.

I have the sheet set up to take the followin
A1 = Miles from previou
A2 = Miles loade
A3 = Previous Hour
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+a
B5 = a4/1

C4 = roundup(b4,0
C5 = rounddown(b5,0

I would like to take the result of A6 and calculate a end date and tim
based on a manually entered start date and time.

Any advice on a formula that will accomplish this

Thanks in advance

 

[Ron Rosenfeld]

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)