Convert feet per minute to meters per second - Formulas In Excel - Microsoft Excel Tutorials

22.  Convert feet per minute to meters per second

A worksheet contains speed data. To convert feet per minute to meters per second, use the calculation described below.

To convert feet/minute to meters/second:

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

Note: To convert the other way around, from meters per second to feet per minute, use the formula =B2*$D$1.

Watch the Video Tutorial - https://www.youtube.com/watch?v=R2_beE6UFjg

Hope You Like This Tutorial - Give Comments