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
|