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

Posted on June 13, 2008 
Filed Under Excel Tips & Tricks

And we are closing the week with another Microsoft Excel Tutorial. I want to show you with this Excel Tutorial how you can convert miles per hour to kilometers per hour and it’s pretty simple.

 

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.

 

Excel-tutorial-converting-miles-km-hour-pic1

 

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

 

Excel-tutorial-converting-miles-km-hour-pic2

 

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

 

Excel-tutorial-converting-miles-km-hour-pic3

 

  • 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.

 

Excel-tutorial-converting-miles-km-hour-pic4

 

 

That’s it for today and for this week. I hope you all enjoyed this week and I’ll talk to you all next week. Have a great weekend.

 

 

Do you want to see more? This is related...


Buzz Up Digg Mixx
Print


Comments

One Response to “An Excel Tutorial for Converting Miles per Hour to KM per Hour.”

  1. Fresh Excel on July 29th, 2008 8:48 am

    Very good tip. Thanks for this.

Leave a Reply