Windows Forum

Ask something
Discussion Locked

Converting inches to decimal in Excel

0 helpful
3 replies

by mrs_doctor_jones

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by dklippert

Use a form of Dollarde.
10.06 for instance in A1 would be 10.5 using the formula Dollarde(A1,12).
See Chip Pearsons explanation at:

http://www.cpearson.com/excel/fractional.htm

(There are no spcaes in the URL)

This may be the formula for 10.06.04 in Cell D6:

=DOLLARDE(VALUE(LEFT(D6,5)),12)+DOLLARDE(VALUE(RIGHT(D6,3)),8)

This discussion is closed to new replies.