Home 
Search 
Today's Posts 
#1




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




convert meters to feet/inches
=ROUND(A1*3.28083990.5,0)&" feet
"&ROUND((A1*3.2808399ROUND(A1*3.28083990.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




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




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




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




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




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




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




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.28083990.5,0)&" feet "&ROUND((A1*3.2808399ROUND(A1*3.28083990.5,0))*12,0)&" inches" ?  David Biddulph "sb1920alk" wrote in message ... =ROUND(A1*3.28083990.5,0)&" feet "&ROUND((A1*3.2808399ROUND(A1*3.28083990.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




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.3048TRUNC(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.28083990.5,0)&" feet "&ROUND((A1*3.2808399ROUND(A1*3.28083990.5,0))*12,0)&" inches" ?  David Biddulph "sb1920alk" wrote in message ... =ROUND(A1*3.28083990.5,0)&" feet "&ROUND((A1*3.2808399ROUND(A1*3.28083990.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 
Display Modes  


Similar Threads  
Thread  Forum  
How do I convert decimal to feet and inches  Excel Worksheet Functions  
convert to feet and inches  Excel Discussion (Misc queries)  
Convert feet/inches to decimal  Excel Worksheet Functions  
How do I convert Meters to Feet and Inches?  Excel Worksheet Functions  
is there a macro that will convert from inches to feet and inches  Excel Discussion (Misc queries) 