View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Please advise on length addition!

In addition to Chips's excellent method, you could enter (in A1) 5 8/12 and
(in A2) 7 9/12
In A3 enter =A1+A2
To keep Excel from rationalizing fractions like 8/12 to 2/3, format the cell
as # ??/12

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"student" wrote in message
...
Can someone advise on how to add length in Excel, for example, I need to
add
5 ft 8 in and 7 ft 9 in. I want an answer to be also in feet and inches.

Gladly appreciate!