How do I convert 4'6" into decimals?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new and this is driving me crazy. I am doing a worksheet where I want
to convert feet and inches into decimal. Does that even make sense?

Any help would be greatly appreciated!
 
Because there are so many different ways that people enter ft' in" it would
be better if you could post a good representative sample of your data rather
than just a single example.

Biff
 
for decimal feet use

=LEFT(A1,FIND("'",A1)-1)+MID(A1,FIND("'",A1)+1,LEN(A1)-1-FIND("'",A1))/12

and for inches use

=LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1-FIND("'",A1))
 
You must log in or register to reply here.

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

Conversions of Decimal Feet to Decimal Inches - Formula?? 0
Excel How To Convert Decimal To Inches 2
change feet and inches to decimal inches 4
Combine functions into one cell 2
Access Convert a decimal time to hours and minutes 2
Display a number in feet inches and fractions of and inch 1
Converting measurements 3
Convert decimals into mm in excel spreadsheet 2

Back
Top