Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21   Report Post  
Old February 17th 10, 01:22 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default 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   Report Post  
Old February 17th 10, 01:59 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 690
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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,762
Default convert meters to feet/inches

Hi,

Am Mon, 15 Jun 2015 05:35:25 -0700 (PDT) schrieb :

100*100m= howmanyfeets


what do you exactly mean?
100m x 100m
or
100 x 100m?

100 in cell A1.
=CONVERT(A1,"m","ft")^2


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #25   Report Post  
Old 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,138
Default 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   Report Post  
Old June 16th 15, 03:44 AM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2015
Posts: 4
Default

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   Report Post  
Old 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
Default 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   Report Post  
Old December 9th 19, 10:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2019
Posts: 2
Default 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   Report Post  
Old December 9th 19, 10:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,762
Default convert meters to feet/inches

Hi,

Am Mon, 9 Dec 2019 13:06:52 -0800 (PST) schrieb :

hello,I tried the formula and it works great, but what if I need to show the fraction also, like (18feet8inches1/8fraction)


try:

=INT(CONVERT(A1,"m","ft"))&" feet "&TEXT(MOD(CONVERT(A1,"m","ft"),1)*12,"# ?/?")&" inches"


Regards
Claus B.
--
Windows10
Office 2016
  #30   Report Post  
Old December 10th 19, 12:33 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2019
Posts: 2
Default convert meters to feet/inches

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert decimal to feet and inches Erik Excel Worksheet Functions 5 October 25th 07 11:54 PM
convert to feet and inches sjl Excel Discussion (Misc queries) 3 February 17th 07 01:31 AM
Convert feet/inches to decimal dingy101 Excel Worksheet Functions 16 February 21st 06 11:18 PM
How do I convert Meters to Feet and Inches? Dave S Excel Worksheet Functions 7 December 16th 05 12:33 PM
is there a macro that will convert from inches to feet and inches cable guy Excel Discussion (Misc queries) 1 June 20th 05 07:29 PM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017