How do I convert 4'6" into decimals?
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))
"Curious" wrote:
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!
|