Adding Feet and Inches

[Hydestone]

I am looking of for a simple worksheet to add feet and inches. Ie: column A has feet and column B has inches. Row 10 (?) would give you the result with feet in A and inches in B.

I can get the result in feet and inches in decimal format in the same cell, but now in separate cells.

 

[shg]

For example, ...?

 

[Jonmo1]

Something like this maybe

Excel 2013/2016
	A	B
1	Feet	Inches
2	10	6
3	3	10
4	7	4
5	6	9
6
7	Total Feet	Total Inches
8	26	29
9
10	Adjusted Feet	Adjusted Inches
11	28	5
Sheet1

Cell Formulas
Range	Formula
A8	=SUM(A2:A5)
A11	=A8+INT(B8/12)
B8	=SUM(B2:B5)
B11	=MOD(B8,12)

 

[macattackpro]

Without an example of what you're looking at I can only guess with a possible solution:

=A1&" ft "&B1&" in"

Or if you're wanting a sum then:

=SUM(A1:A9,INT((SUM(B1:B9)/12)))&" ft "&MOD(SUM(B1:B9),12)&" in"

 

[Scott T]

maybe

Excel 2010
	A	B	C
1	feet	inches
2	10	6
3	3	10
4	7	4
5	6	9
6
7
8
9
10	28	5	total
Sheet4

Cell Formulas
Range	Formula
A10	=SUM(A2:A9)+INT(SUM(B2:B9)/12)
B10	=SUM(B2:B9)-(INT(SUM(B2:B9)/12)*12)

 

[Hydestone]

Jonmo1, macattackpro, and Scott T - Thanks guys. These are all great and work as I need them to!

John

 

[Jonmo1]

You're welcome.