Excel
From notebook
(Difference between revisions)
(Created page with "Convert feet and inches in x'y" type notation into inches or centimetres =LEFT(H6,(FIND("'",H6)-1))*12+MID(H6,(FIND("'",H6)+1),(FIND(H$3,H6)-FIND("'",H6)-1)) Where H3 contains th...") |
|||
| (One intermediate revision not shown) | |||
| Line 1: | Line 1: | ||
Convert feet and inches in x'y" type notation into inches or centimetres | Convert feet and inches in x'y" type notation into inches or centimetres | ||
| - | =LEFT( | + | |
| - | + | =LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1)) | |
| + | |||
| + | =2.54*(LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1))) | ||
Latest revision as of 07:18, 26 June 2014
Convert feet and inches in x'y" type notation into inches or centimetres
=LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1))
=2.54*(LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1)))
