need to multiplicate foot and inches times a given number

**gcastilleja** · 10-16-2008, 12:48 PM

Last week i posted this same problem and i got one answer but it didn't work properly. i thanked but I couldn't tell the person who helped me that this did not worked because i was unable to have internet. I'm, once again asking you for your help with this: i have to multiply several measures in foot and inches times a full number e.g. 4' 2" times 2 would be 8' 4" (result in foot and inches too) but i can't do this, it returns an error #value! i think this happens because the cell where 4' 2" is stored is recognized as text instead of number. Can you help me once again, i am attaching an example of what i need. BTW i'm working on excel 2003. Thanks a lot in advance.

Gabo

**martindwilson** · 10-16-2008, 01:48 PM

perhaps something like this split the ft/ins into seperate columns
format inches column as fractions eighths

**gcastilleja** · 10-16-2008, 02:35 PM

Thank you very, very much Marty, that is a good solution. I'm going to use your formula when entering data, that will be just what i need, but right now i have like 2000 entries already stored in the format that i showed before so to split them is going to take me a while, or is it there a way to split them and make it work your way? thank you in advance.

**daddylonglegs** · 10-16-2008, 03:05 PM

Try this formula in C2 copied down

=B2*LEFT(A2,FIND("'",A2)-1)+INT(SUBSTITUTE(REPLACE(A2,1,FIND("'",A2)+1,""),"""","")*B2/12)&"'-"& TEXT(MOD(SUBSTITUTE(REPLACE(A2,1,FIND("'",A2)+1,""),"""","")*B2,12),"# #/8")&""""

It may not work for all your data, how do you show exactly 4 feet?....for the above to work then zero inches need to be included , i.e. like 4'-0"

**gcastilleja** · 10-16-2008, 04:12 PM

That was exactly what i need, and it is ok with the format because it is stored the way it works good. martindwilson and daddylonglegs, once again i tahnk you both i appreciate your help. Saludos desde Mexico.
Gabo