Formula to add feet and inches


Is there a formula that can add feet and inches together?

For example, I need to add all these figure together to get one number in feet and inches.

346' 11"

349' 7"

346' 2"

342' 4"

351' 6"

357' 9"


I may need to convert it all to inches first. I am using this formula but I cannot get the right side of the formula to work and I am not sure why.

=VALUE(LEFT(Width@row, FIND("'", Width@row) - 1)) * 12 + VALUE(RIGHT(SUBSTITUTE(Width@row, """, ""), LEN(Width@row) - FIND(" ", Width@row)))

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!