How to add feet and inches together
How to add feet and inches together
(OP)
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#
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#





RE: How to add feet and inches together
RE: How to add feet and inches together
Thank you
RE: How to add feet and inches together
If your values are in rows instead of columns, then hide a row.
RE: How to add feet and inches together
thread770-161789: Inches to Feet-Inches