Changing KM to MPH

[Chuckmerken]

I could really use some help with this. Is there a way to change KM to MPH on this 2010 Excel spreadsheet adding 2 additional columns and some formula...Really stuck

https://drive.google.com/open?id=1cGZLjwaY_N3abteQCJ7nHMUFzFdbyeiy


HELP

 

[Fluff]

Hi & welcome to MrExcel
Try
=CONVERT(A1*1000,"m/hr","mph")

 

[Scott Huish]

Perhaps:
=CONVERT(K3,"km","mi")

 

[GR00007]

For more convert options you can check out:
https://blogs.technet.microsoft.com...-watch-quickly-convert-measurements-in-excel/

 

[Macropod]

Yet another way:
=J3/1.609344
Likewise for column K.