Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 4th 08, 09:09 PM posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 210
Default convert meters to feet/inches

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

  #2   Report Post  
Old June 4th 08, 09:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 100
Default convert meters to feet/inches

=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches"

Here I'm converting the value in A1 from meters to feet using 3.2808399 feet
per meter. The first part truncates the decimal protion and adds, "feet" and
the second part truncates the integer portion and convert it to inches and
adds "inches"

"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

  #3   Report Post  
Old June 4th 08, 09:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 897
Default convert meters to feet/inches

One way:

Assume the # of meters is in A1:

To get feet, put this in B1:

=INT(CONVERT(A1,"m","ft"))

To get inches, put this in C1:

=ROUND(MOD(CONVERT(A13,"m","ft"),1)*12,1)


Put it together:

=B1&" feet and "&C1&" inches"


--JP

On Jun 4, 4:09*pm, 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


  #4   Report Post  
Old June 4th 08, 09:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default convert meters to feet/inches

One way:

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


In article ,
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

  #5   Report Post  
Old June 4th 08, 10:02 PM posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 210
Default convert meters to feet/inches

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 article ,
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




  #6   Report Post  
Old June 4th 08, 10:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 100
Default convert meters to feet/inches

=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 article ,
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


  #7   Report Post  
Old June 4th 08, 10:12 PM posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 210
Default convert meters to feet/inches

thank you!!!

"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 article ,
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

  #8   Report Post  
Old June 4th 08, 10:18 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 100
Default convert meters to feet/inches

I guess you don't need the Value function, so =CONVERT(SUBSTITUTE(A1,"
feet","")+SUBSTITUTE(B1," inches","")/12,"ft","m") would work too.

"Ann" wrote:

thank you!!!

"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 article ,
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

  #9   Report Post  
Old June 4th 08, 10:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default convert meters to feet/inches

Better to divide by 0.3048, rather than to multiply by what isn't exactly
the reciprocal.
Also, why are you using the strange ROUND construct, rather than using TRUNC
(or INT if the number is positive, as your ROUND only works for positive
numbers)?

Isn't =TRUNC(A1/0.3048)&" feet "&ROUND(MOD(A1/0.3048,1)*12,0)&" inches" a
bit easier than
=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches" ?
--
David Biddulph

"sb1920alk" wrote in message
...
=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches"

Here I'm converting the value in A1 from meters to feet using 3.2808399
feet
per meter. The first part truncates the decimal protion and adds, "feet"
and
the second part truncates the integer portion and convert it to inches and
adds "inches"

"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



  #10   Report Post  
Old June 4th 08, 10:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default convert meters to feet/inches

Checking again in the negative number case, it does need something a bit
more complicated, such as:
=TRUNC(A1/0.3048)&" feet "&ABS(ROUND((A1/0.3048-TRUNC(A1/0.3048))*12,0))&"
inches"
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Better to divide by 0.3048, rather than to multiply by what isn't exactly
the reciprocal.
Also, why are you using the strange ROUND construct, rather than using
TRUNC (or INT if the number is positive, as your ROUND only works for
positive numbers)?

Isn't =TRUNC(A1/0.3048)&" feet "&ROUND(MOD(A1/0.3048,1)*12,0)&" inches" a
bit easier than
=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches" ?
--
David Biddulph

"sb1920alk" wrote in message
...
=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches"

Here I'm converting the value in A1 from meters to feet using 3.2808399
feet
per meter. The first part truncates the decimal protion and adds, "feet"
and
the second part truncates the integer portion and convert it to inches
and
adds "inches"

"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







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:44 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