EXCEL - Quick ETA Calculator

I am developing a calclator that will estimate the time and date of arrival, based on three factors:
- Trip Mileage
- Average Miles Per Hour
- Number Of Drivers

I need to give quick resonses to arrival questions and it is easy to make mistakes.

Note: A single driver can only drive 11 hours and then must be Off Duty for 10 hours. Two drivers can theoretically drive continuously, with no Off Duty time.

I can calculate the Total Transit Time, but now I need to add it to the departure time and date, to return the Day-Of-The-Week, Time, and Date of arrival.

See attached calculator.

Any assistance or insight that can be provided would be greatly appreciated.

Tosagua

 Excel---Quick-ETA-Calculator.xls
TosaguaAsked:
Who is Participating?
 
barry houdiniCommented:
This formula in B14 will give arrival time and date

=B5+C5+C11/24

You can then format B14 to show, day date and time, see attached

regards, barry
27502962.xls
0
 
TosaguaAuthor Commented:
barryoudini,

Beautiful, elegant, excellant.

You have made my life easier.

Thank you,

Tosagua
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.