Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add feet and inches together 2

Status
Not open for further replies.

XxTWOBONExX

Structural
Apr 16, 2008
2
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#
 
Replies continue below

Recommended for you

That's because you are changing the value to text with your formula. Add your values before you change them to feet & inches.
 
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
 
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.
 
Perhaps the following thread will be of interest (although it is long)....

thread770-161789
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor