How do I convert Meters to Feet and Inches?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave S - 16 Aug 2005 22:49 GMT

I need to convert Meters to Feet and Inch measurments. I need it in
fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.
Ex. 1 Meter
= 3 1/2 Feet

Reply to this Message

Dave R. - 17 Aug 2005 00:00 GMT

What I looked has 1 meter = 3.28 feet, not 3.5 feet. Put meters in E8 and
use this formula:

=INT(E8*3.28)&" "&TEXT(MOD(E8*3.28,1),"##/##")

> I need to convert Meters to Feet and Inch measurments. I need it in
> fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.
> Ex. 1 Meter
> = 3 1/2 Feet

Reply to this Message

Zorba.Eisenhower@gmail.com - 17 Aug 2005 13:29 GMT

Look at the CONVERT function in the analysis toolpak.

Here's an extract from the Excel 2003 Help file:

Distance From_unit or to_unit
Meter "m"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
Foot "ft"
Yard "yd"
Angstrom "ang"
Pica (1/72 in.) "Pica"

Pip pip
Zorba

Reply to this Message

Ron Rosenfeld - 17 Aug 2005 02:13 GMT

>I need to convert Meters to Feet and Inch measurments. I need it in
>fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.
>Ex. 1 Meter
>= 3 1/2 Feet

I assume you want the reduced fraction. i.e. you would want 1/2 rather than
8/32.

If you have the Analysis Tool Pak installed, you may use this formula:

=mROUND(convert(A1,"m","ft"),1/32)

And custom format the cell as fraction with up to 2 digits.

If you don't have or want the ATP installed, then:

=ROUND(A1*3.28084*32,0)/32

(still formatting the cell as fraction with up to 2 digits).

--ron

Reply to this Message

martin fuller - 16 Dec 2005 09:21 GMT

When I enter this formular or the one in 'Convert measurements' i.e.
=CONVERT(A2,"M","ft") the return I get is '#NAME?
Why is this and how can I obtain the result that one meter = 3' 3" Etc

Thanking you in anticipation.

> >I need to convert Meters to Feet and Inch measurments. I need it in
> >fractional format I.e. 1/4, 1/2, 3/8, 5/16, 8/32.
[quoted text clipped - 17 lines]
>
> --ron

Reply to this Message

Niek Otten - 16 Dec 2005 10:32 GMT

Tools>Add-ins, check Analysis Toolpak
BTW use lowercase "m"

Signature

Kind regards,

Niek Otten

> When I enter this formular or the one in 'Convert measurements' i.e.
> =CONVERT(A2,"M","ft") the return I get is '#NAME?
[quoted text clipped - 28 lines]
>>
>> --ron

Reply to this Message

martin fuller - 16 Dec 2005 11:23 GMT

Niek,
Yes the addin was not ticked. Ticked this and it works. Why on earth does
not MS put this on their help pages?!
Many thanks for your help and prompt reply -Thank you

> Tools>Add-ins, check Analysis Toolpak
> BTW use lowercase "m"
[quoted text clipped - 31 lines]
> >>
> >> --ron

Reply to this Message

Niek Otten - 16 Dec 2005 11:33 GMT

I don't know about your HELP, but mine says:

"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

Signature

Kind regards,

Niek Otten

> Niek,
> Yes the addin was not ticked. Ticked this and it works. Why on earth does
[quoted text clipped - 37 lines]
>> >>
>> >> --ron

Reply to this Message