Mph/eta

Ego92

New Member
Joined
Oct 25, 2018
Messages
4
Trying to create a spreadsheet which tells me the ETA to a destination but also gives the MPH based off of passing a certain point. The mph and eta to the next location would update based off the actual time entered for the previous location passed. If I were going a distance of 6150 feet which is mile post 1.16 what would be the mph if you were to leave point 0 at a certain time. And what would be the ETA to the next location which is 9621 feet from the starting point. Will try to add pictures of an example if able to
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
.
You are going to need more information than what you have already provided. I don't see a means of determining the speed travelled or the ETA based on what you have given so far.
 
Upvote 0
Example:

Distance/ft Mile Post Time. Mph. ETA
0. 0.00. 15:35:00. 6.0 avg
6015. 1.14. 15:58:58. 2.85. 15:46:24
11605. 2.20. 16:19:51 3.04. 16:21:14
16506. 3.13. 16:39:10. 2.88 16:38:10
19858. 3.76. 16:51:30. 3.09. 16:52:23
24197. 4.58. ??? ?????



And so on and so until the end destination
 
Upvote 0
Maybe my next comment helped although the format came out different than what I typed it as. But you will have a distance and a time. As you enter the time to that mile post the speed should update on how many mph it is moving and what would be the eta to the next location as well
 
Upvote 0
.
You can post a sample workbook to DROPBOX.COM or Google cloud or something similar. Paste the link in your post.
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,239
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top