Newsroom Update
The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >
The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >
What would be the correct way to type feet and inches (not decimal form), in a cell in Numbers? I would like to add them up too.
Example:
A1- 5’7”
A2- 6’1”
A3- 5’8”
A4- the total of A1 thru A3
iPhone 12 Pro Max, iOS 16
Hi Jed,
Use a column for feet and another column for inches.
I have added a Header row and a Header column for labels.
Formula in D2: IF(OR(B2="",C2=""),"",B2&"'"&C2&"""")
Fill down to Row 5.
Formula in B5: SUM(B2:B4)
Fill right to C5
Now to convert the totals to real feet and inches.
Formula in B6: B5+INT(B5÷12)
Formula in C6: MOD(C5,12)
Another example
Regards,
Ian.
Hi Jed,
Use a column for feet and another column for inches.
I have added a Header row and a Header column for labels.
Formula in D2: IF(OR(B2="",C2=""),"",B2&"'"&C2&"""")
Fill down to Row 5.
Formula in B5: SUM(B2:B4)
Fill right to C5
Now to convert the totals to real feet and inches.
Formula in B6: B5+INT(B5÷12)
Formula in C6: MOD(C5,12)
Another example
Regards,
Ian.
Hi Ian,
Thank you for the answer. Very helpful too.
jed
Feet and Inches Format in Numbers
