Hi,
Please forgive me if I'm not doing this correctly.
Months ago I came across an old thread that solved my original problem . Love it.
Orginal post by pramodpandit @: https://www.mrexcel.com/board/members/pramodpandit123.460240/
I used the formula =SUBSTITUTE(A1,".","'-")&"""" to represent 11.6 as 11'6". per the thread
As a construction worker the above formula is super awesome to use for quick data input for field meetings. I find myself needing to convert to decimals at times. Is there a way to take that easy representation of 11'6" and turn into a decimal into column C for when I'm referencing topographic points on a survey. It would be 1 divided into 12 = .08333. <---This representing 1"
I would greatly appreciate some help.
Please forgive me if I'm not doing this correctly.
Months ago I came across an old thread that solved my original problem . Love it.
Orginal post by pramodpandit @: https://www.mrexcel.com/board/members/pramodpandit123.460240/
I used the formula =SUBSTITUTE(A1,".","'-")&"""" to represent 11.6 as 11'6". per the thread
As a construction worker the above formula is super awesome to use for quick data input for field meetings. I find myself needing to convert to decimals at times. Is there a way to take that easy representation of 11'6" and turn into a decimal into column C for when I'm referencing topographic points on a survey. It would be 1 divided into 12 = .08333. <---This representing 1"
I would greatly appreciate some help.