Mph/eta

[Ego92]

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

 

[Logit]

.
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.

 

[Ego92]

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

 

[Ego92]

Sorry trying to have an example just hard without being able to post pictures

 

[Ego92]

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

 

[Logit]

.
You can post a sample workbook to DROPBOX.COM or Google cloud or something similar. Paste the link in your post.