Convert feet and inches to inches

**shernandez** · 07-08-2009, 11:56 AM

In column A1, I have 12'-5 (general) and want to covert to total inches (65). I have tried several formula's but to nothing seems to work. Do I need to set the solution column to specific type (i.e general) or am I missing something :-( ...

Tried : =(1*(LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,2)))+IF(LEN(A1)=LEN(SUBSTITUTE(A1,"1/2",""))

and nothing happened?

**shg** · 07-08-2009, 12:00 PM

Welcome to the forum.

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

**shernandez** · 07-08-2009, 02:48 PM

I placed your formula in cloumn b1 and it has an error .. any other suggestions

**shg** · 07-08-2009, 02:55 PM

Yes -- post a workbook.

**shernandez** · 07-09-2009, 12:15 PM

Thank You ... I attached the sample excel worksheet

**Paul** · 07-09-2009, 12:37 PM

If you put SHG's formula in B1 you get an error because A1 has the word "Length" in it, not a measurement. Try putting it in B2 and adjust all of the references of A1 to A2. Once you do that the formula should work and you can fill it down column B as far as necessary.

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

**rupak007** · 11-16-2012, 03:58 AM

how to convert 4.11 Feet (4 Feet & 11 Inches) to 59 inches...........

**Paul** · 11-16-2012, 05:41 PM

Welcome to the Forum Rupak007, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.