feet and inches to meters

S

scott

what formula will allow me to convert feet and inches to meters. current
format of cell is 5’05.00â€
 
D

David Biddulph

=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
 
M

macropod

Hi Scott,

Assuming the actual number is 505 and it's just a custom format you're using to display it as 5’05.00â€, you could use a formula
like:
=(INT(A1/100)*12+MOD(A1,100))*0.0254
 
S

scott

thank you very much
--
Thanks in advance


David Biddulph said:
=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
--
David Biddulph





.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert meters to feet/inches 21
change feet and inches to decimal inches 4
Meters to Feet and Inches 2
Is it possible to display feet and inches in one cell ? 4
Can I format one cell so that it affects another cell? 4
Display a number in feet inches and fractions of and inch 1
How do I use feet and inches (including fractions of inches) 2
How do I convert Meters to Feet and Inches? 7

Top