convert units of measure - feet to inches

[Eamon]

Hope this is of some help...

A1 = Feet
B1 = Inches (Format B1 as Fraction)
C1 enter =A1+(B1/12)
i.e. A1 = 12
B1 = 3 3/4
C1 = 12.31

See...
http://www.mvps.org/dmcritchie/excel/formula.htm#carpentry

Formula to convert feet and inches to
inches? Ex. 10'9.25" to 129.25"

=CONVERT(LEFT(A1,FIND("'",A1)-1),"ft","in")+SUBSTITUTE(MID(A1,FIND("'",A1)+1
,255),"""","")

or

=(LEFT(A1,FIND("'",A1)-1)*12+SUBSTITUTE(MID(A1,FIND("'",A1)+1,255),"""",""))

the first is using a function from ATP and has to be installed or else a
name error will be the result under format>cells>number use a custom format
like

General\"



Eamon

 

[hutch]

Can someone point me to a way to convert feet-inches to decimal feet or
decimal inches.

Like this:

Given - 12'-3 3/4
convert to 147.75

 

[hutch]

Thank you Eamon! This helped tremendiously.
I was able to tweek this to support input strings like 12'-3 15/16
which is what I want.

=12*(VALUE(LEFT(A1,FIND("'",A1)-1)))+(MID(A1,FIND("-",A1)+1,255))

 

[Eamon]

Thanks for your comments glad to hear it has been of some help.

Eamon