Time and distance formula
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"drumnotme118" schrieb im Newsbeitrag
...
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

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