kilometers to miles and yards

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Statement (2007) 5
Convert Miles to Kilometeres 4
convert kilometers to miles 7
excel to figure miles per gallon 5
Additional information: Cast from string "" to type 'Double' is not valid. error 4
Calculating speed 3
road graph 2
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0

Top