Speed = distance/time, so you have to have two out of the three pieces
of information to calculate the third. For instance:

A1: <Distance travelled
A2: <time
A3: =A1/A2 <==== Speed

You can use the Convert() function from the Analysis Toolpak Add-in
(Tools/Add-ins) to convert from imperial to metric, so if A1 is in
miles, then

A4: =CONVERT(A1,"mi","km")/A2

will give km/hr. Alternatively, you could use the conversion factor that
1 mile = 1.609344 km:

A4: =(A1 * 1.609344)/A2

to convert mph to kph.



In article ,
drumnotme118 wrote:

How do I obtain speed/hr and distance with excel for both imperial and
metric?

How do I obtain distance from meters to feet like .195m to feet?

Thanks