![]() ![]() It wants to default to either halves, quarters, eighths, sixteenths, tenths or hundredths - not a combination - just one of those not multiple-possibilities-of-those. I was thinking of trying to incorporate the Fraction cell format somehow, but I haven't been able to get that to behave with varying situations. Getting the decimal back to a number w/fraction (for those that have a fractional-part) is still going to be difficult to achieve though, unless someone else knows some wizardry in that regard. That assumes your measurements are in the A column (starting A2). If, and only if, you will always have the feet marker (eg, the ' character) and a dash separating feet from inches and the inches marker (eg, the " character) in every instance, the following formula will give you your decimal: =(LEFT(A2,FIND("'",A2)-1)) If no slash, safe to assume no fraction?ĭoing a 2nd reply in case you saw the first and wouldn't know to look for an edit. If we have a slash in there, we've got a fraction. Otherwise, safe to assume 0 (zero) inches? Same for the inches marker (the double-quote-mark). I'm wanting to see what you're seeing because I have (another) sneakin'suspicion that what you'll be typing won't always have feet in it, perhaps won't always have inches in it, and likely won't always have a fractional-piece in it.įor example, will you always have the feet marker in there (the single-quote-mark in other words)? Can I assume if it's there, we have feet to calculate, and if it's not there, we're safe to assume 0 (zero) feet? That adds some complications to the mix because we'll have to check the cell to make sure what / which elements exist before we can extract them on-the-fly and be able to calculate them accordingly.Ĭan you work up some sort of mock-up and take a screenshot of the various types of input you'll be working with? I had a sneakin'suspicion that's what you were looking for (and for the reason you referenced hehe). They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.Inches can have a fraction (3 1/4) or decimal (3.25 or 3,25). ![]() This calculates either way (feet/inches to decimal feet or vice versa). To convert further, 1/8" is almost 1/100 th of a foot. Feed it your values for either a foot with inches or a decimal of a foot and click on Convert to get the equivalent measurement. In the text, youll find out how to use this fraction to decimal calculator, what numerators and denominators are, what is 7/8 as a decimal, and how to convert a fraction to a decimal. We also include a calculator which does the math for you. Included also is the 1/8" conversion to decimals of a foot from 1" to 2". For simplicity this table starts off with 1 to 12 inch equivalents in decimals of a foot. This is a table of conversions from inches to decimal feet, useful for surveying. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |