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))
 
Back
Top