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" <go_chrisg@discussions.microsoft.com> wrote in message
news:ADC67987-DF62-407F-980A-83CCEEE8440C@microsoft.com...
> 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<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

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" <go_chrisg@discussions.microsoft.com> wrote in message
> news:ADC67987-DF62-407F-980A-83CCEEE8440C@microsoft.com...
> > 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<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
>
>
>

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

"go_chrisg" <go_chrisg@discussions.microsoft.com> wrote in message
news:3B48861C-CB9B-460B-8C06-139D614C005C@microsoft.com...
> 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" <go_chrisg@discussions.microsoft.com> wrote in message
>> news:ADC67987-DF62-407F-980A-83CCEEE8440C@microsoft.com...
>> > 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<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
>>
>>
>>

"go_chrisg" <go_chrisg@discussions.microsoft.com> wrote in message
news:3B48861C-CB9B-460B-8C06-139D614C005C@microsoft.com...
> 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