Fresh Excel Tips

For this example, we are asked to convert a list of values that are in feet per minute to meters per second. To achieve this we are going to use the conversion value as an absolute value. Here is how we achieve this:

How to convert feet per minute to meters per second:

1. Open Microsoft Excel. In a worksheet, enter the data shown in image below or just use your own data.
2. Select cell C2 and enter the conversion value 196.858144.
3. Select cells B2:B10 and type the following formula: =A2/$C$2.
4. Press CTRL+Enter.

convert feet per minute to meters per second

To convert from meters per second to feet per minute, use the formula =B2*$C$2.

1. Convert Miles per hour to Km per hour in Excel.
2. How to Use the HOUR function to calculate with 100-minute hours
3. How to Round Time to the nearest 15 minute in Excel
4. Convert Liters to Barrels, Gallons, Quarts and Pints in Excel
5. Convert from Fahrenheit to Celsius & vice versa in Excel