Length conversion from cms to feet and inches

Please can somebody provide me with an Excel function that will convert cms into feet and inches? For example, I am looking to take 167.64 cms and convert it into the result 5’ 6”. It is straight forward to convert 167.64 cms to feet by multiplying by 0.0328084 to arrive at 5.5000001’ and then to take the fraction 0.5000001 and convert it to 6”. However, I would like to post the resultant conversion of 167.64, which is 5’ 6” into the next door cell as shown below.

Cell A1 Cell B1
167.64 cms 5’ 6”

Hi
Try

Formula:

Please Login or Register  to view this content.

where cm2feet is 0.032808399

167,64 5' 6,0''

Thanks Marvin for the mathematical tuition. However, there remains a further conundrum, is it possible to do everything you have shown in a single function that displays the result of converting 167.64 cms from say cell A1 straight into cell B, next door, showing as 5' 6"?

BTW, I see you're from Seattle, Washington and I wondered what you made of the bombshell result of Trump as your successor President.

Best of British,
Just William

Hi Jose,

You're a genius. Many thanks to Portugal!

Best of British,
Just William

Hi again Marvin,

Jose Augusto, posted the following solution, which works a treat!

=INT(B4*J7) &"'" & TEXT(MOD(B4*J7,1)*12," 0''"), where B4 is my A1 (167.64 cms) and J7 is the conversion factor from cms to feet being 0.032808399.

Thanks though for your prompt response.

Bless you,
William ;-)

Thanks Macropod,

Your suggestion gives the answer to the conversion of 167.64 cms to feet and inches as 5.5, which is correct but I wanted to display that as 5' 6". As you may have noticed, Jose Augusto, posted the following solution, which works a treat!

=INT(B4*J7) &"'" & TEXT(MOD(B4*J7,1)*12," 0''"), where B4 is my A1 (167.64 cms) and J7 is the conversion factor from cms to feet being 0.032808399.

Thanks all the same for your suggestion.

Best wishes,
Just William ;-)

Hi Macropod,

I'm sorry but I don't see how either of your solutions produce 5 6/12ths. Whichever I deploy in my spreadsheet the result is always 5.5. However, as I previously explained, I would like to display the result in a single cell as precisely 5' 6". The function =INT(A1*cms2feet) &"'" & TEXT(MOD(A1*cms2feet ,1)*12," 0''"), where A1 is 167.64 cms and cms2feet is the conversion factor 0.032808399.

I take your point about 0.032808399 not being an accurate conversion factor. I presume you would agree 3937/1200/100 giving 0.032808333 is more acceptable?

Thanks again for your much appreciated assistance.

Hi
Define Name cm2feet as

=1/30.48

Originally Posted by AliGW

How about this?

=CONVERT(A1,"cm","ft")

Hi @AliGW
The problem is not accuracy or formula. Is format: not 5.5, not 5 6/12 but 5' 6''