Free Microsoft Excel 2013 Quick Reference

convert ft and inches to inches with fractions

Im trying to convert this Plate 1/2"x2'-6 9/16" in excel to look like this 1/2"x30 9/16". is there a way to strip the word "plate" off and convert the 2'-6 9/16" to 30 9/16" im new to excel any help would be great...


Post your answer or comment

comments powered by Disqus
Convert feet and inches to decimal feet.

--------------------------------------------------------------------------------

In column A1, I use for example: 6-11 (Text) and want to covert to decimal feet in column B1 (6.9166666666667).
Have been working on this for a week! With no luck.
6-11 is easy to type in a field and represents 6'-11"
Thanks

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

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

Thanks for the help in advance.
hrg

I have used the following formula to convert to inches,
=LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3))),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3)))-1))

But when I divide it by the conversion factor inches to meters I get errors
=(LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3))),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3)))-1)))/0.0254

Please can you assist me.

Thanks

In column A1, I have 12'-5 (general) and want to covert to total inches (65). I have tried several formula's but to nothing seems to work. Do I need to set the solution column to specific type (i.e general) or am I missing something :-( ...

Tried : =(1*(LEFT(A1,FIND("-",A1)-1)*12+MID(A1,FIND("-",A1)+1,2)))+IF(LEN(A1)=LEN(SUBSTITUTE(A1,"1/2",""))

and nothing happened?

Does anyone know a formula where I can convert a height that is in feet and inches (e.g. 4.11, 5.4, etc) into metres?

Does anyone know how to convert "yes" and "no" to "1" and "0" in excel? I'd
like then to do analysis using SPSS. Thank you.

All,

I've been working on a project for work for the last couple weeks and this forum has proven to be invaluable when it comes to working through issues. I couldn't find this one through searching, so alas i will post.

One element of this project is converting a length from textbox "txtLength." I have this box setup so it can be only whole numbers, no fractions/decimals/letters/etc. However, i need to manipulate this number and change it's length so i can later print the length to a Bill of Materials. It's not practical to print this length as inches, because the length could be as high as 360 inches.

Here's where i'm at, i'm having a difficult time wrapping my head around the correct way to approach this.


	VB:
	
 LengthConverter() 
     
    Dim sLength As String 'This is the final format of "XXFT XXIN"
    Dim iLength As Integer 'This is the original format of "XXIN"
     
    iLength = txtLength.Value 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Any direction you could provide would be a big help!
Thanks,
Nate

Edit: Working through this a little more and it should be something like this, i just don't know the correct functions in excel:


	VB:
	
 
Public Sub LengthConverter() 
     
    Dim iLengthFT As Integer 
    Dim iLengthIN As Integer 
    Dim sLength As String 
     
sLengthFT = (iLength/12) With a method To drop the remaining decimal To the Next calculation of: 
    sLengthIN = (Remainder(iLength/12))*12 'Round this up to whole number
     
    Then would need a method To concatenate the "FT" And "IN" units To the End of the integers. 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Am i getting closer?

I've seen the other posts but they deal with smaller numbers or different
formats. I need to convert 188.76 inches to feet and inches.

I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction

for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")

and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8

But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?

I have size data given in millimeters and converting it into inches in 16ths
fraction format. How do I reduce resulting fractions to lowest term - I don't
want to see 8/16 but do want 1/2.

Hi all,

I'd like to find a way of converting feet and inches (expressed as, for example = 12'4") to metres (m). I won't be using any imperial fractions.

I've had a play with the convert funtion which manages to do one or the other (eg feet to metres, inches to metres) but not both together. Of course I'm sure it does but my excel knowledge is woeful. Any help would be greatly appreciated.

I have several thousand cells of infomation in feet and inchs I need to be
able to do calculations on which I think I can only do by converting them
into their decimal equivalents.

Does anyone know a function or some other way to convert these?

How do I format a cell for user to enter in ft and inch
format such as 4'33". Then how do I multiply 2 cell
together to produce square foot. Example A1=4'33" and
B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

I have feet and inches in a cell as text and want it to be inches as a decimal.
Before (2"-4 1/2") after (28.5)
I would like to us a formula or number type to convert.

I have converted Lotus 1-2-3 spreadsheets that are just shy of functioning
properly in the Excel environment. Lotus apparently treats text in cells as 0
or 1 values so that when they are added or multiplied (with operands) it has
no net effect on the value that results. Excel returns an error message when
using operands to sum/multiply values with text. I did discover that Excel
does what I need it to do when using the =SUM() and =Product() functions. I
updated all the formulas by hand in one sheet and then found that there are
69 more sheets and the formulas are irregular.

Does anyone have any idea how to write a VBA macro that will parse the
spreadsheet and convert all the formulas to use SUM and/or PRODUCT instead of
" + " and " * "?

Example
Convert: " =ROUND ( (+CO34 +DA34 -AA33) * DD34,0) "

To: " =ROUND (PRODUCT (SUM (CO34,DA34,-AA33) ,DD34) ,0) "
or
To: " =ROUND (PRODUCT (SUM (CO34) + SUM (CO34) - SUM (AA33) ,1) * PRODUCT
(DD34,1) ,0) "

Both methods seem to give me the same result. The second way is easier for me
to approach, but I haven't been able to nail it down.

Thank you!

How do I format a cell for user to enter in ft and inch
format such as 4'33". Then how do I multiply 2 cell
together to produce square foot. Example A1=4'33" and
B1=3'33" which is equal 14.42 Sq.Ft.

Thanks.

How do i convert hours and minutes (ex. 1:30) to minutes (90)?

Dear,

I have an Excel sheet in with 2 columns: Column A holds a date in the European format "dd/mm/yyyy" and column B holds a number in the European format "#.###.##0,00".

This data is used to complete a listbox in a userform so the user can choose with which date and number to continue some calculations.

Now, when completing the as follows, the values are casted to strings with the wrong value:
Code:
 UCList.AddItem
        UCList.List(UCList.ListCount - 1, 0) = MyCell.Value
        UCList.List(UCList.ListCount - 1, 1) = MyCell.Offset(0, 1).Value
If I check in the "Wachtes" window, mycell.value = 65,864356134631 (sixty five and then some decimals) and mycell.offset(0,1).value = 03/02/2008 (February 3rd). After assigning the values to the list, these value become 65864356134631 and "02/03/2008". If I later on call this date form the UCList, the date becomes the 2nd of March and the number a huge number (=+/- 6*10^14 ).

The problem probably is most likely caused by the cast to string when completing the list and the cast to double or date when reading the list values.

Is there a way I can tell VBA that I live in Europe and that we use a different date system? Just like you can set it in Excel in Tools>Options>Internation>Number Handling?

I can solve this by using
Code:
 UCList.AddItem
        UCList.List(UCList.ListCount - 1, 1) = format(MyCell.Value,""#,###,##0.00")
        UCList.List(UCList.ListCount - 1, 1) = format(MyCell.Offset(0, 1).Value,"dd/mm/yyyy")
but this is just one of those patches which does not really solve the root problem.

In addition, this continuously switching from US to European date and number format, makes my code quite confusing.

Any help on this will be highly appreciated.

I have a spreadsheet that tracks time - I currently convert hours and minutes
by adding the hours and multiplying the minutes by 1.666667. example 8 hours
and 30 minutes - =8+.30*1.666667 - results in 8.50. I have to manually
enter this for all hours and minute I want to convert to hours and tenths. I
am looking for a formula that can be entered in a cell that will
automatically convert the hours and minutes computed in the previous cell to
hours and tenths.

Hello, I have got two colums one is b8 which is feet and one is c8 which is inches. I also have this day by day for example, b8 and c8 are day 1 and b9 and c9 are day 2. What i need is the for example, b8 is 5' and c8 is 1" then b9 is 5' and c9 is 3". I need to be able to enter that 2nd day in and then calculate the feet and inches into barrels which is 1 inch=1.16 barrels. This is kinda hard to explain but if there is anyone who is smarted than me and know what i am talking about. PLEASE HELP!!! THANKS IN ADVANCE

Hi. Please HELP. I need to find out how to convert minutes and seconds (eg. 4:21) into seconds only in EXCEL. Anyone that can help?

I need to convert hours and minutes 1:45 (One Hour and 45 Minutes) into total
minutes... Any ideas

what formula can I use to convert hours and minutes to a decimal form???

Currently I have 37:30 (thirty seven hours: 30 minutes) but in order to multiply it i need it to be 37.5 hours.

Any help would greatly be apprciated...

thanks so much

sklnxbones

I want to be able to type in a cell decimal feet and have the cell display feet and inches to a prescribed format.

For example, if I type 6.738 in a cell, I want it to display 6'-8 7/8".

I know how to use the lentext() and feet() modules, but they are not cell formats.

Any ideas?


No luck finding an answer? You could always try Google.