Converting meters to feet & inches

What is your full your question, converting meters to feet or averaging numbers given as ft-in?

In an attempt to answer the question in your post, the problem with data entered as feet-inches is that those are strings, not numbers. You'll have to convert them into numbers first. Each foot-inch "number" needs to be converted into an actual number then the average can be calculated. There are three parts to it: getting the feet, getting the inches, and adding them together. It can get very complicated. The complications arise when trying to handle all the possible formats of the foot-inch "number", some may have feet only, some may have inches only, some may be feet and inches. It makes it difficult to parse the string into feet and inches. I'd recommend two columns to enter the data, one for feet and one for inches. That would be much easier.

On the subject of converting meters to feet-inches where the meters are in cell B2,

feet =INT(B2*3.28084)

inches =MOD((B2*3.28084*12),12)

So the full string of feet & inches will be =INT(B2*3.28084)&""" "&ROUND(MOD((B2*3.28084*12),12),3)&"'"

This does not go so far as formatting the inches as inches and a fraction, it will give decimal inches. If you want the inches to be fractional (like 1 1/2') you will have to calculate the feet in one cell, the inches in another, format the inches cell to be a fraction, then in a third cell combine the two numbers into a string.

Kappy

Thanks for the input, but how do I get .28084 to the imperial version (such as 6' 11 1/2').

The system seems to be on a base 10 concept (metric), but the Imperial system seems to be on a base 12 system (6' 11 1/2"). Is there a way to have the computer move from a base 10 to a base 12?

1 Meter = 3.28084 feet.

It's all Base 10. Translate the feet measurements to decimals, i.e., 6' 11 1/2" = 6.95833 feet. Simply divide the inches component by 12 to convert to a decimal - 11.5/12 = 0.95833.