Conversions of Decimal Feet to Decimal Inches - Formula??

Joined
Apr 15, 2012
Messages
1
Reaction score
0
Hello,
I have to make a excel document in which I have length and width in feet and inch format.
eg.
10.01
in which 10 is feet and .01 is inch

I have all the length and width values in the above format.
And what I want to do is convert the inch value (10.01) to feet value (.01=.08 feet)
Just like the calculator here does.. http://daveosborne.com/dave/articles/decimalfeet.php

Like
10.01=10.08
10.02=10.16
10..03=10.25
...and so on...

Here is table of conversions from inches to decimal feet. But I don't know how to get a formula for this in excel...???? :confused:

Inch Decimal of a Foot
1 inch 0.0833
2 inches 0.167
3 inches 0.250
4 inches 0.333
5 inches 0.417
6 inches 0.500
7 inches 0.583
8 inches 0.667
9 inches 0.750
10 inches 0.833
11 inches 0.917
12 inches 1.000



Please help me..??!?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top