kilometers to miles and yards

C

Cyril the Squirrel

I want to convert kilometers into miles and yard, but i am not very clear on
how convert works, can someone suggest a way that will do this easily.
I want 171.797 km in a format something like "***mi****yds"
 
B

Bob Phillips

=INT(CONVERT(A1,"km","mi"))&" miles
"&TEXT(MOD(CONVERT(A1,"km","mi"),1)*1760,"#,##0.00")&" yards"
 
J

Jazzer

Hi Cyril,

If you kilometers are in A1, try this:

=INT(A1*0.621371192)&" m
"&ROUND((A1*0.621371192-INT(A1*0.621371192))*1760,0)&" yds"

This will give 171.797 km = 106 mi 1319 yds

- Asse
 
Top