Can I add 2ft 7in plus 5ft 8in and get 8ft 3in as an an...

C

C.

How can I enter and format the data in feet and inches and get an answer in
the same units (without pre-converting everything to inches?)

When I add the data, I do not want the answer in decimals. Just feet and
inches.
 
J

Jason Morin

If you have your measurements formatted such that feet
are in column A and inches are in column B, then try:

=INT(SUM(A:A)+SUM(B:B)/12)&"'-"&ROUND(MOD(SUM(A:A)+SUM
(B:B)/12,1)*12,0)&""""

Simply enter the numbers in col. A and B without adding '
or ".

This formula assumes that the numbers in col. B are whole
numbers. Nothing like 3.3 or 3 1/3.

HTH
Jason
Atlanta, GA
 
J

Jerry W. Lewis

Another approach would use the custom format "# ??/12". Then you could
enter the values in cells as
2 7/12
5 8/12
and sum to get
8 3/12

Jerry
 
Top