how to add feet and inches?

V

vitruviuz

trying to do a spreadsheet that adds feet (') and inches (") but can
figure out how to do it if its even possible. for example 14'-6"
8'-2"=
I try to format the cell but there is no category for measurement.
is there any way to do this in excel??? hel
 
B

Bill Ridgeway

Yes, you need to break the problem down a bit -

Separate columns for feet and inches
Total the two columns
Under the inches total you need the formula =[cell address of inches
total]/12
Under the feet total you need the formula =INT[cell address of the above
line] This takes the full number what we used to call the carry over
The last cell of the feet column needs to be the total of the last two feet
cells. This the total feet
The last cell of the inches column needs the formula =([cell address of last
cell in inches column]-INT(cell address of last cell in inches column))*12
This is the total inches

You could, perhaps be very clever and concatenate (posh word for joining up)
the two. To do this add in a cell the formula
=[cell address of total feet]&"_feet"&[cell address of total inches]&"
inches]

Sounds difficult? but it's really easy. Good luck!.

Bill Ridgeway
Computer Solutions
 

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