convert feet and inchs to inchs only

D

ddelzell

Trying to convert from 15'6" to inchs only, is this possible and how do I do
it? The info is in a2 need to see the answer in a3
 
D

Dewi

Trying to convert from 15'6" to inchs only, is this possible and how do I do
it? The info is in a2 need to see the answer in a3
Click to expand...
how is the 15'6" getting into A2?

If it can be put in A2 for feet and A3 for inches with the answer in
A4 then it's a doodle

in a4 =(a2*12)+a3
 
B

Biff

Hi!

Here's one way:

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

Biff
 
Top