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
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
2,956
.
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

New Member
Joined
Oct 25, 2018
Messages
4
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

New Member
Joined
Oct 25, 2018
Messages
4
Sorry trying to have an example just hard without being able to post pictures
 

Ego92

New Member
Joined
Oct 25, 2018
Messages
4
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

Well-known Member
Joined
Aug 31, 2016
Messages
2,956
.
You can post a sample workbook to DROPBOX.COM or Google cloud or something similar. Paste the link in your post.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,973
Messages
5,411,586
Members
403,380
Latest member
ifog671

This Week's Hot Topics

Top