Hi
Have a read of Chip's site:
http://www.cpearson.com/excel/FeetInches.htm
It gets a bit complex but it should set you off in the right direction!
Hope this helps.
Andy.
"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!