How do I convert 4'6" into decimals?

C

Curious

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!
 
B

Biff

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
 
S

Sloth

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