See the DOLLARDE and DOLLARFR functions in help.
=DOLLARFR(DOLLARDE(5.08,12)+DOLLARDE(7.09,12),12)
returns 13.05. These functions are part of the Analysis ToolPak
add-in, so you'll need to have that add-in loaded. Go to the
Tools menu, choose Add-Ins, and check Analysis ToolPak in the
list of available addins.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"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!