How can I format a cell to accept feet and inches and add them

J

Jack

I am trying to get a formula to add the inches and feet together. The
program will add a base of ten with no problem. How do I get the program to
accept additions on a twelve base? I do not want to use separate columns for
feet and inches. In other words if I wanted to add 5' 06" to 6' 05" the real
answer would be 11' 11" but the program gives an answer of 12.01. How do I
stop this? Thank you in advance for any assistance you may have in this
matter.
 
B

Bernard V Liengme

Would it help to enter values in form 5 5/12 for 5ft 5inch?
Format cells with #0 ??/12 to stop 5 /6/12 becoming 5 1/2

best wishes
Bernard
 
D

Don Guillett

Here is one I used for SQUARE fee in writing an estimating program for a
builer client.
=(C14+IF(D14<>" ",D14/12,0))*(E14+IF(F14<>" ",F14/12,0))
 
K

K.S.Warrier

hi,
If you can use 3 columns (in one row),one for feet,one for inches and one
for converting feet and inches as total inches(feet*12+inches).This can be
continued for others below this row.if you want to get total of thes two
values, first total the total of inches column and then convert this as feet
and inches by formula
1)in feet cell =int('total inches'/12) and 2)in inches cell =mod('total
inches',12)
which will give the desired result.
K.S.Warrier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top