If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|