Converting Feet/inches To Decimal Equivalent

Feb 18, 2006

I am new to Excel but not programming and I am looking for a recommendation for the following. I have a spreadsheet that simply takes the length and width of an area and computes the square feet and yardage and other sundry items. I am entering the feet/inches as follows:

Example: 11.3 (equals 11/ft 3/inches)

The correct decimal conversion should be 11.25 but, obviously, it does not know that the number to the right of the decimal point is an indicator of inches. (ex.: .5=.42, .7=.58, .9=.75, .11=.92)

I have approached this from the stand point of an IF condition, finding the position of the "." and grabbing everything to the right (+1) but I understand that the limitation is 7 nested IFs.

Can someone get me kick-started on what the best approach would be to get my entry to convert to the true decimal equivalent? Currently, I am simply doing the conversion from memory but I would rather automate this sometimes errant approach.

View 9 Replies


ADVERTISEMENT

Converting Decimal To Feet - Inches (fractional)?

Mar 24, 2009

This is a continuance of the Q and A below. Except the answer below converted a decimal like 1.44 to and answer like 1' 5.28".
except the final format I am after requires the 5.28" to be fractional such as:
1' - 5 1/4"

Is there a formula for this format?

View 9 Replies View Related

Feet In Decimal Form To Feet / Inches?

Dec 26, 2013

I need a formula to convert:

3.759 to 3' 9"
3.974 to 4'
4.005 to 4'

I have this currently:

=INT(D9)&"' "&ROUND(TEXT((D9-INT(D9))*12,"#"),0)&CHAR(34)

However, 3.974 returns 3' 12" and 4.005 returns a #VALUE error. I'm picky about the spaces. I'd like it formatted as I have it now.

View 3 Replies View Related

Convert Decimal Feet To Feet And Inches

May 18, 2011

I am currently working on cut sheets for my current project. I need to take my decimal feet (ie 1.55) and display them as feet and inches (1' 6 5/8") not (1' 6 3/5")

I have a formula which is this

=INT(F17)&"' "&TEXT(12*(F17-INT(F17)),"# #/#")&CHAR(34),

It works but the problem is the fractional inches 6 3/5" i need them to display in 1/8 1/4 1/2 when applicable. Is there something i could add to this formula to make my inches read like a measuring tape (1' 6 5/8") 1/8 1/4 1/2??? I attached the spreedsheet for review.

Question.xlsx‎

View 6 Replies View Related

Convert Feet And Inches To Decimal Feet?

Feb 3, 2012

I am working in excel 2003 and I need to convert feet and inches into decimal feet. Example: 15'-10 5/8" to 15.88542

15'-10 5/8" will be in say, column B, and the conversion will be in say, column Q.

This formula will be copied all the way down the page.

how to do this or can it even be done in this version?

View 8 Replies View Related

Conversions Of Decimal Feet To Decimal Inches - Formula?

Apr 15, 2012

I have to make a excel document in which I have length and width in feet and inch format.

E.g. 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.. [URL] ........

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

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

View 7 Replies View Related

Convert Feet/inches To Decimal

Feb 16, 2006

Is there a way to convert a value in a cell that is 2'-3 1/2" to adecimal such as 27.5"?

excel 2003 SP2

View 14 Replies View Related

Decimal Numbers To Feet And Inches

Jan 19, 2004

Is there a way to store a text style that will allow me to convert decimal numbers into feet and inches in the same cell?

I want to be able to type in a number like 3.5 and have it read 3'-6".

View 9 Replies View Related

Calculating Inches Then Converting To Feet

Mar 16, 2009

I am trying to calculate volume in inches then in feet using 2 methods to check my work.

Method ....

View 9 Replies View Related

Feet And Inches

Mar 29, 2007

I need to convert inches to feet and inches in this format:
88 1/2 = 7' 4-1/2"
...so that if 88 1/2 is in cell A1, cell B1 will show 7' 4-1/2".
The exact syntax of B1 must be as shown.

View 14 Replies View Related

Feet & Inches Formula

Jun 21, 2007

I am making an excel spreadsheet that auto fills in a lot of items for a construction company. One of the most important ones is the Roof Pitch.

1/12 pitch is 1 inch rise every 12 inches.
2/12 pitch is 2 inch rise every 12 inches.

I would like it to auto calculate this and add it to the over all height of the building.

Example:

A house is 20 feet wide with a 2/12 pitch.
Since the Ridge is in the center we divide the Width in half.

So a 2/12 pitch over a span of 10 feet is 20 inches

View 9 Replies View Related

Adding And Multiplying Feet And Inches

Mar 21, 2014

I am creating a spreadsheet for some deliveries. The pieces I have are all in feet and inches and multiplied by a certain quantity. I need a formula to run this and give me feet as an answer.

I have 4 cells, in A1 I have feet without the foot mark (20) and in cell B1 I have inches without the " (5). In cell C1 I have 20. How do I write a formula to do the following:

20'-5" multiplied by 20 = Answer in D1 408'

View 2 Replies View Related

Convert Decimals To Feet & Inches

Nov 16, 2006

I need help shrinking down my formula to make it fit in one cell.

Right now, the way i have it, it spans across (7) different cells to get the results i desire. Is there a way i can make this shorter?

A11 – This is where the decimal value of a number is inputted.

B11 – This is the final display after running A11 through the formulas below

Here are my formulas: ...

View 9 Replies View Related

Conversions To & From Feet-Inch To Decimal/base 10

Nov 14, 2009

I often use feet and inch inputs for calulations. I prefer to input a typical feet & inch input into one cell using this format: ft-n.

example: 12ft 9in would input as 12-9

This would need to be converted into a decimal for calcualtions. Also I would like to convert from Decimal back to ft-in.

View 9 Replies View Related

Decimal To Fraction (Inches)

Oct 28, 2008

Could someone please tell me what is wrong with this formula. I have been looking at it for so long, I can't even concentrate .....

View 9 Replies View Related

Inches And Decimal Fraction

Jun 23, 2008

I am working on a simple calculater, what I want to do is figure sq. inches my problem is every thing I try the decimals won't calculate right,, this is a example of what I want to do

8.25x10.75= 81 sq"

View 9 Replies View Related

Excel 2007 :: Formula For Decimal To Ft And Inches?

Mar 3, 2014

believe this is a simple formula I just cant seem to get it right. Example: H1 has 859.375 and I need H2 to be 71' 7 3/8

View 5 Replies View Related

Formula (or Chart) For Converting Centimeters To Inches

Mar 13, 2014

Formula (or a chart) for converting centimeters to inches.

View 1 Replies View Related

How To Setup Custom Paper Size Of 4 Inches By 6 Inches

May 1, 2012

How, using PageSetup and xlPaperSize properties, to setup a custom paper size of 4 inches by 6 inches???

View 3 Replies View Related

Converting Decimal Days To Time?

Aug 17, 2014

Excel VBA Macro.

I need to convert a decimal (0.602083333) to Time (14:27) but how to do this.

I would like to do this in a VBA Macro, to add to my existing code.

View 5 Replies View Related

Converting Comma To Decimal Point

Aug 25, 2009

I've just imported a file into a UK version of Excel from a German made datalogger. The decimal points (which should look like this 0.0) all appear as comas (0,0) with the result that Excel can't read them.

View 5 Replies View Related

Converting Units And Decimal Places.

Nov 23, 2009

I have a simple spreadsheet that allows the user to enter a dimension in metric or inches. I want to display the other units in the adjacent cell. In cell A1, the units are "Metric" or "Inch" in a pull down list. In cell A2, the value is entered.

In cell A3 i want to show the value in the other units. So if A1 is Metric, then take A2 and divide by 25.4. And if A1 is Inch, then take A2 and multiply by 25.4.
Also, if A1 is Inch, then display 2 decimal places in A3, and if A1 is Metric, then display 3 decimal places in A3. Is this possible?

View 3 Replies View Related

Time Sheets - Converting Decimal Point

Nov 16, 2008

I have just started a job and given a task to input some timesheets that were done manually. The problem is that I used decimal point instead of the colon. When I try and format the cells I do not get the real time.

Here is an example: ....

View 7 Replies View Related

Converting Decimal Numbers To Minutes And Seconds

Jul 27, 2009

I have an excel sheet with a row of numbers example below. These numbers represent the length of time that a telephone call was. The problem is they are decimal numbers (units of 100) but they represent seconds and minutes of a phone call which change up one number when the seconds hit 60 ...

View 9 Replies View Related

Converting Decimal Numbers To Text With Dot Numbers

May 27, 2006

we work with both Lotus 123 and Excel 2003. Lotus will be gone next year, but for now, the official mean to publish our reports is Lotus. With my work, I copy/paste a Lotus page to Excel. I use the following macro to convert Lotus format numbers (which Excel considers as text) to real numbers:

Sub ForceToNumber()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
With wSheet
. Range("IV65536") = vbNullString
.Range("IV65536").Copy
.UsedRange.PasteSpecial xlPasteValues, xlPasteSpecialOperationAdd
End With
Next wSheet
End Sub

Source : http://www.ozgrid.com/forum/showthre...087#post184087. The problem is that I need to send back this data in Lotus. Excel considers decimal numbers with a coma as real numbers and numbers with a dot as a text. This previous macro fixes that. However, Lotus works the other way. Only numbers with a dot are considered real numbers. So I would need to find a way to code a macro that converts any numbers in the Excel sheet to a number with a dot. It's a bit like doing the opposite operation.

View 3 Replies View Related

Index - All Up All Square Feet

Mar 13, 2014

I have 6 rows A1-A6(sheetsize), they can be 1 of 8 numbers. (16,14,12,10, 5/8, 1/2, 3/8, 3/16) these are all metal gauges. The cell next to them B1-B6(sheetgauge) has a number that refers to how much sq ft each of these sheet metal sizes has. I would like a cell below A30 to add up all the sq ft in B1-B6 if it is 16 gauge. Then A31 will add up all the 14 gauge, etc.

How is this possible without having a huge formula.

Here is my standard formula, but it wont add the B cells together if more than one of the same sheet sizes.

=index(sheetsize,match(A31,sheetgauge,0))

View 2 Replies View Related

Paste Two Decimal Number In Excel Without Extra Decimal Places Appearing

Aug 13, 2009

I have a vba macro that takes data from one workbook and pastes it into another workbook. In doing this I have declared a few variables of type single (I only need two decimal precision). However, when I copy the values from the cells on the source workbook and paste them into the target workbook, the numbers end up having 12 decimal places. Ultimately, this extra precision causes my totals to be off by .01 or more after a while. I have tried rounding the number as I pull it off the source workbook into the variable, but that didn't matter. How do I solve this problem? Code for pulling data from source workbook:...

View 2 Replies View Related

Formatting Group Of Cells To Have Different Decimal Rules Based On Decimal Value

Aug 3, 2006

Basically, I want to format a group of cells to display 1 decimal figure if the number is not a whole number. If the number is a whole number (or if the rounded first decimal place is 0) I want it to display no decimal.

View 9 Replies View Related

Removing Decimal Point While Maintaining # Of Decimal Places

Jun 10, 2009

I need to convert a column of numbers currently formatted with 2 decimal places e.g. 112.12 to 4 decimal places (without the decimal point). I need the end result to be 1121200. I've tried a few different suggestions given on the forum previously but can't seem to retain the 4 decimal places that I require.

View 4 Replies View Related

Convert Or Format Decimal To X Digits Without Decimal Point

Aug 8, 2008

I am trying to create a unique sample code by putting together the values of other cells that a user will input. It's all working well apart from the last part, where I am trying to include a decimal number. I want the decimal number to appear without the central "." and in a four digit format. e.g. 2.5 would appear as 0250, 14.25 would appear as 1425. This is the formlua I am using currently:

=IF(ISBLANK(B4),"",IF(LEFT(C4,1)="w",(B4&"-"&TEXT(F4,"YYMMDD")&C4&TEXT(G4,"HHMM")),(B4&"-"&TEXT(F4,"YYMMDD")&C4&LEFT(TEXT(H4,"00"),2)&RIGHT(TEXT(H4,"00"),2))))

However, where the value of H4 is 2.5, I am getting a result of 0303 (I've put this part in bold). I have attached a small spreadsheet to aid understanding.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved