Changing Kilometres to Miles

[Safequip]

I am currently doing a team challenge where all members have agreed to walk/run/cycle 100 miles in September, most members are sending the results in KM is there a formula I can use to quickly convert to Miles?

Thanks in advance

 

[Luke M]

Thankfully, there's a handy CONVERT function.
=CONVERT(A2,"km","mi")

 

[Safequip]

Thankfully, there's a handy CONVERT function.
=CONVERT(A2,"km","mi")

Thanks Luke

 

[Somendra Misra]

Hi,

Just as an alternate if you multiply Km value with 0.621371 this will give you the distance in miles.

Regards,