Conversions of Decimal Feet to Decimal Inches - Formula??

S

shubhamdev

New Member
Joined
Apr 15, 2012
Messages
2
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.gif


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..??!?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
Hi,

Welcome to MrExcel.

There's a built-in CONVERT formula in Excel. Assuming your data is in cell A1.
=INT(A1)+CONVERT(A1-INT(A1),"in","ft")
Edit: If 0.01 part indicates 1 inch then we need to multiply by 100 like:
=INT(A1)+CONVERT((A1-INT(A1))*100,"in","ft")
 
Last edited:
Upvote 0
Thank you guys for your support guys.. I'm still learning excel and facing difficulty with formulas.. and I'm unable to solve it.. so please me.. :(

415201212037pm.jpg


this is how I want my table to be...
I will insert the values of length and width and formula should convert in into ft.
2.11 into 2.91 (0.11 inch=0.91 feet)
6.7 into 6.58 (0.7 inch=0.58 feet)
And then I have to convert it into square feet.

Any idea how to do it..?? Please help..:confused:
 
Upvote 0
There is an inconsistency in your data between columns A and B. Column A has 1 inch as .01 but Column B has 7 inches as .7 instead of .07. This is why Mikericson and taurean's formulas are not delivering your desired results. Change B2 to 6.07 (as well as correcting B3 & B4), and enter Mikericson's formual in C2 as =A2+(88/12)*MOD(A2,1) and then copy down & accross to D4. Cell E2's formula should be =C2*D2.
 
Upvote 0
2 ft. 11 inches = 2 + 11/12 feet = 2.916666667 which rounds to 2.92 rather than the posted 2.91
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Formula calculate rank in groups of column range
Replies
2
Views
565
Preacherman771
P

Forum statistics

Threads
1,215,128
Messages
6,123,206
Members
449,090
Latest member
bes000

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top