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

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)

"go_chrisg" wrote in message
...
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)

Chris

It's close, but not quite right. Firstly I assume A1 is in the format
ft<spacein. 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

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))

"IC" wrote:


"go_chrisg" wrote in message
...
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)

Chris

It's close, but not quite right. Firstly I assume A1 is in the format
ft<spacein. 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

Hi!

Try this:

A1 = 3<space6 meaning 3'6"

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

Returns 3.5

Biff

"go_chrisg" wrote in message
...
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))

"IC" wrote:


"go_chrisg" wrote in message
...
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)

Chris

It's close, but not quite right. Firstly I assume A1 is in the format
ft<spacein. 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

"go_chrisg" wrote in message
...
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))

.... 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