How do i convert feet and inches to a decimal value?

G

go_chrisg

I have an assignment that shows me this equation but it doesnt seem to
work,
=LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12)
 
I

IC

go_chrisg said:
I have an assignment that shows me this equation but it doesnt seem to
work,
=LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12)
Click to expand...

Chris

It's close, but not quite right. Firstly I assume A1 is in the format
ft<space>in. Your formula needs to look for the space, so you need to add a
space between all 3 instances of "". Secondly, the final "find" argument is
wrong. As it stands, it will only pick up the first digit after the space
for the inches. Deleting the -1 from after the final A1 will cure this.

Ian
 
G

go_chrisg

hmmmmm it seem i still am hving problems....heres the corrections to it
=LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND("
",A37))/12))
 
B

Biff

Hi!

Try this:

A1 = 3<space>6 meaning 3'6"

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

Returns 3.5

Biff
 
I

IC

go_chrisg said:
hmmmmm it seem i still am hving problems....heres the corrections to it
=LEFT(A37,FIND(" ",A37)-1)+((MID(A37,FIND(" ",A37)+1,LEN(A37)-FIND("
",A37))/12))
Click to expand...

.... which is exactly what I suggested, except the change of cell reference
from A1 to A37 (which I couldn't have guessed from your original post).

Anyway, I'm glad it's sorted.

Ian
 
Top