Remember Me?

#21
February 17th 10, 12:22 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 5,651
convert meters to feet/inches

On Mon, 15 Feb 2010 10:06:02 -0800, matt
wrote:

One problem that I have while doing this is that I'd like the results to be
more precise.

I would like 12.35 meters to come out as 40' 6.25"

I'd even like to have the ' and " instead of feet/inches. Is all that a
possibility?

Thanks for help.

=INT(CONVERT(A1,"m","ft"))&"' " &
ROUND(MOD(CONVERT(A1,"m","in"),12)*4,0)/4 & """"

--ron

#22
February 17th 10, 12:59 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2008 Posts: 690
convert meters to feet/inches

I would like 12.35 meters to come out as 40' 6.25"

Not ideal, but a slightly different method might be the following.
If you can live with the leading zero on the inches...

40.' 06.22 ''

=TEXT(DOLLARFR(CONVERT(A1,"m", "ft"),12),"0.' 00\.00 ''")

or just use the formula, and make it a custom cell format.

= = = =
Dana DeLouis

On 2/15/2010 1:06 PM, matt wrote:
One problem that I have while doing this is that I'd like the results to be
more precise.

I would like 12.35 meters to come out as 40' 6.25"

I'd even like to have the ' and " instead of feet/inches. Is all that a
possibility?

Thanks for help.

"sb1920alk" wrote:

=CONVERT(VALUE(SUBSTITUTE(A1," feet",""))+VALUE(SUBSTITUTE(B1,"
inches",""))/12,"ft","m")

"Ann" wrote:

and if i was to reverse this formula? from feet and inches back to meters?
if feet is in a1 and inches is in b1
thanks guys

"JE McGimpsey" wrote:

One way:

=INT(CONVERT(A1,"m","ft"))& " feet, "&
TEXT(MOD(CONVERT(A1,"m","in"), 12), "0 ""inches""")

In ,
wrote:

i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for
example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia

#23
June 15th 15, 01:35 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2015 Posts: 1
convert meters to feet/inches

On Thursday, 5 June 2008 01:39:03 UTC+5:30, Ann wrote:
i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for
example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia

100*100m= howmanyfeets
#24
June 15th 15, 02:05 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,797
convert meters to feet/inches

#25
June 15th 15, 07:11 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2015 Posts: 1,182
convert meters to feet/inches

On Thursday, 5 June 2008 01:39:03 UTC+5:30, Ann wrote:
i'm trying to convert from meters to feet and inches (not just feet
or not just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches
for example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia

100*100m= howmanyfeets

Perhaps...

=ROUNDDOWN(CONVERT(2,"m","ft"),0)&"ft,
"&MOD(ROUNDUP(CONVERT(2,"m","in"),2),1)*12&"in "

...which returns...

6ft, 9in

...on which Claus (our resident formula wizard) may be able to make more
efficient.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

#26
June 16th 15, 03:44 AM
 Junior Member First recorded activity by ExcelBanter: Jun 2015 Posts: 4

Use the =CONVERT(B5,"m","ft")
and format the cell as
#" feet" 0/12 "inches"

So if text is required =TEXT(CONVERT(11.87,"m","ft"),"#"" feet"" ?/12 ""inches""")
will yield
38 feet 11/12 inches

Regards
Brian
#27
June 28th 15, 04:08 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2015 Posts: 1
convert meters to feet/inches

If A1 has the value 2, use
CONCATENATE(TEXT(INT(CONVERT(A1,"m","ft")),"####0" ),
" feet,",TEXT(MOD(INT(CONVERT(A1,"m","in")),12),"#0" )," inches")
to give you 6 feet, 6 inches

If A1 has 100, you will get 328 feet, 1 inches

Ignores the fraction of an inch

On Mon, 15 Jun 2015 05:35:25 -0700 (PDT), wrote:

On Thursday, 5 June 2008 01:39:03 UTC+5:30, Ann wrote:
i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for
example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia

100*100m= howmanyfeets

#28
December 9th 19, 09:06 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2019 Posts: 2
convert meters to feet/inches

hello,I tried the formula and it works great, but what if I need to show the fraction also, like (18feet8inches1/8fraction)
#29
December 9th 19, 09:46 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,797
convert meters to feet/inches

#30
December 9th 19, 11:33 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2019 Posts: 2
convert meters to feet/inches

wow works great!!! thank you so much, really appreciate it

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Erik Excel Worksheet Functions 5 October 25th 07 11:54 PM sjl Excel Discussion (Misc queries) 3 February 17th 07 12:31 AM dingy101 Excel Worksheet Functions 16 February 21st 06 10:18 PM Dave S Excel Worksheet Functions 7 December 16th 05 11:33 AM cable guy Excel Discussion (Misc queries) 1 June 20th 05 07:29 PM

All times are GMT +1. The time now is 11:56 AM.