Time and distance formula

[drumnotme118]

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

 

[Frank Kabel]

Hi
you may provide some more details which data you already have and what
you want to calculate. E.g. give some examples

 

[JE McGimpsey]

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.