Convert Miles per hour to Km per hour in Excel.
A worksheet contains speed in miles per hour. To convert the data to kilometers per hour, use the following calculation.
To convert miles per hour to kilometers per hour:
- In a worksheet, enter the data shown in the figure below for this example.
- Select cell C2 and enter the conversion value which is 0.621371.
- Select cells B2:B11 and type the following formula: =A2/$C$2.
- Then press Ctrl+Enter.
Afterwards, you can format the results to two decimal places. This works in Excel 97, 2003 and 2007
Convert mph to kph
To convert from kilometers per hour to miles per hour, use the formula =B2*$C$2.
