How to add feet and inches together 2

[XxTWOBONExX]

Hi folks,
I have taken this formula =(A1)&"'-"&TRIM(TEXT(ROUND(MOD(A1,1)*12*16,0)/16,"# ??/??")&"""")
which converts from decimal to feet and inches.
What i am trying to do is to take the answer to each one of these cells and add them together for a grand total.
for instances A1+B1=C1
A2+B2=C2
C1+C2=D3
When i do this i receive a value#

 

[jghrist]

That's because you are changing the value to text with your formula. Add your values before you change them to feet & inches.

 

[philoshophy]

That's true. But it's just the display in the screen and print. Is there any macros or custom format so that we can perform mathmatical calculations without conersion. If some body knows that will be great

Thank you

 

[SteveGregory]

You could keep the numerical values in a column adjacent to the column with the Feet-Inches text display. Then you could hide the column with the numerical values.

If your values are in rows instead of columns, then hide a row.

 

[Clyde38]

Perhaps the following thread will be of interest (although it is long)....

thread770-161789