CONVERT MILES PER HOUR TO KM PER HOUR USING MICROSOFT 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:

1. In a worksheet, enter the data shown in Figure 1-21, or use your own data.
2. Select cell D1 and enter the conversion value 0.621371.
3. Select cells B2:B8 and type the following formula: =A2/$D$1.
4. Press <-Ctrl+Enter->.

CONVERT MILES PER HOUR TO KM PER HOUR USING MICROSOFT EXCEL

Note: To convert the other way around, from kilometers per hour to miles per hour, use the formula =B2*$D$1.

Microsoft Excel Tutorials, Convert Miles per hour to KM per Hour in Excel, Microsoft Excel Video Tutorials, Basic Tutorials, Applications of Microsoft Excel, World of Tutorials