An Excel Tutorial for Converting Miles per Hour to KM per Hour

If you want to convert miles per hour to kilometers per hour you’ll need to follow the next steps.

I’m starting this Excel tutorial with this column.

Then you’ll need to fill in the conversion rate somewhere in your spreadsheet. I did this in C1.

Now select Cells B2:B9 and type in the following formula =A2/$C$1. And the other way around is =A2*$C$1

And press CTRL+ENTER

All you have to do now is select Cells B2:B9 again, right click and select properties. Now you the number tab because you might want to have your digits in a 2 decimal number.