My company does many engineering spreadsheets in which feet and inches need to be converted to decimals.
The source data usually looks something like this…
06- 06- 00
where the first number is the number of feet, the second is the number of inches, and the the third is 8ths of an inch. (For this example the value would be 6.5 feet)
Right now the data entry people enter each number into a separate cell and then use a formula to convert to inches and then add everything together.Is there a way to type all three numbers in the same cell and then come up with the same results. I’ve seen this done in reverse.