« back to Woodworking Skill Share forum
| Forum topic by CharlieM1958 | posted 492 days ago | 3673 views | 5 times favorited | 73 replies | ![]() |
![]() |
|
492 days ago |
Okay, so it’s a slow day at work, but this has been a pet peeve of mine. I often run across a measurement given in millimeters, and wish I had a handy reference to convert that number into fractional inches. There are a lot of charts and calculators online that will give you decimal equivalents, but nothing I could find that will quickly tell me that 17mm equals pretty close to 11/16ths. So I used my Excel skills and some free time to come up with my own. You can get it here: http://www.loyno.edu/~cbmarsh/mmtofraction.htm
I have included columns to get you to the nearest 16th, 32nd, or 64th, depending on how precise you care to get. The PDF version will be easiiest for most of you, but I’ve included a link to the Excel file as well, in case you want to monkey around and modify it to best suit your own needs. -- Charlie M. "Woodworking - patience = firewood" |
|
492 days ago |
Very cool. Thanks. -- When you give someone a chance it may well be their last. |
|
492 days ago |
Thanks, Charlie! This will be great laminated and hanging in the shop. Lew |
|
492 days ago |
Thanx! a good reference to keep around….. now if everyone would only work in metric…. we wouldn’t have these problems to begin with would we? lol… sorry, but metric just makes sense, and working in fractions is a pain in the a$$ sometimes. -- When in doubt - There is no doubt - Go the safer route. |
|
492 days ago |
Thanks Charlie. Print out nice on the color laser. -- What happens in the workshop stays in the workshop. No wait that doesn't sound right. Karson Southern Delaware karson_morrison@bigfoot.com † |
|
492 days ago |
I couldn’t agree with you more. But the old inches and fractions system just wont die. If I’m not mistaken, it was something like 30-40 years ago when it was officially announced that the U.S. would be going to the metric system. I guess the wheels of progress turn slowly, huh? :-) -- Charlie M. "Woodworking - patience = firewood" |
|
492 days ago |
Charlie, I really apprciate your sharing this with us. This will come in soooo handy! |
|
492 days ago |
That’s pretty handy… looks like a good reference to put in the shop… Thanks Charlie! -- As iron sharpens iron, so one man sharpens another. (Proverbs 27:17) † |
|
492 days ago |
That’s going in the shop. Thanks for the effort! -- You're a unique and special person, just like everyone else. |
|
492 days ago |
I definitely appreciate your work on this but I won’t be using it. sorry. Canada had the metric system forced on us a number of years back and one thing I have learned in that time is to never convert. -- If we learn from our mistakes, I'm getting a fantastic education. |
|
492 days ago |
LOL, MrWoody! I’ll try not to take it personally. :-) -- Charlie M. "Woodworking - patience = firewood" |
|
492 days ago |
I know what you mean I have sliding ruler that works well but get yourself a tape measure with both English on top and Metric at the bottom -- --<<<<<< I will not stop until I get it right. >>>>>>-- |
|
492 days ago |
Thanks Charlie. I use both out in the shop. At time I find that metric is more accurate. The chart is super. -- The significant problems we face cannot be solved by the same level of thinking that created them |
|
492 days ago |
It prints well in good ole b&w too. Thanks Charlie, great idea. |
|
492 days ago |
Thanks Charlie, I am lucky, I have a built in converter on my cell phone:) Callum -- For wood working podcasts with a twist check out http://thetimberkid.com/ |
|
492 days ago |
Thanks, Charlie. Powerful tool, that Excel. One of the best things Bill Gates ever sprang on us (I recall trying to use Lotus123 with a great deal of wailing and gnashing of teeth). -- "Bordnerizing" perfectly good lumber for over a decade. |
|
492 days ago |
Doug, do we have to say anything nice about Bill Gates? (I do love Excel, though. I’ve used it for years and am still finding new things I didn’t know it could do.) Callum, be careful using that cell phone in the shop! :-) -- Charlie M. "Woodworking - patience = firewood" |
|
492 days ago |
Charlies, Thanks for the converter… Now I won’t have to write one! -- Chris |
|
492 days ago |
Thanks for the chart, Charlie. I’m sure it will come in handy. Very colorful too. You DO have too much time on your hands, to sit down and create this. Or is it too much Luzianne (w/chickory)? -- Tim -- http://tmuli.com |
|
492 days ago |
THIS SITE MAKES CONVERSIONS EASY. -- Only the Shadow knows.................... |
|
491 days ago |
John, that’s a good site. I have a little conversion calculator on my desktop that does the same thing also. But for me, the missing element that I always seem to be looking for is the mm to fractional inches conversion. I could not find that on the internet anywhere. (I’m sure someone will provide a link to prove me wrong.) -- Charlie M. "Woodworking - patience = firewood" |
|
491 days ago |
I had a guy once told me he wanted a board ripped two and two thirds inches wide. I told him i couldn’t help him because it wasn’t on my ruler. Lol As for metric. I admit its a better system. I think the answer to why we haven’t converted can be found in Americans general distaste for most all other things European. Now i’ve stepped in it! -- miles125, Alabama.."Architecture is frozen music"" |
|
491 days ago |
How un-politically correct of you, Miles! Besides, we don’t dislike everything European. Particularly those French and Italian women come to mind (at least the ones who shave their underarms). There…. now I’ve insulted Europeans and feminists in a single comment. :-) -- Charlie M. "Woodworking - patience = firewood" |
|
491 days ago |
Shame on you Charlie, now we are having the metric -v- imperial discussion again ;) Too bad we don’t have 12 fingers. 12 is a more natural number for archetectural measurement since it can be evenly divided in so many ways. 10 sucks since it can only be divided evenly by 2 and 5. It’s multiples are just as bad. 20 can only be divided by 2, 5 and 10 while 24 can be divided by 2, 4, 8, and 12 which as you can see are all themselves divideable into halves and quarters because they don’t have that ugly 5 in the middle. -- Scott - Chico California http://chicowoodnut.home.comcast.net |
|
491 days ago |
Nice to see a comrade step in it with me! As for converting metric to fractions. You really get a skewed result. Because theres too much rounding off going on. Lets say you decide 17mm is 11/16ths. Then when you multiply 11/16ths by say…50…you get a far different answer than 17 mm x 50. Getting to intimately know fractions by their decimal equivalents is the way to go for math purposes. After years i pretty much know the decimal equivalents of all fractions from 1/16th to 15/16ths in my head. -- miles125, Alabama.."Architecture is frozen music"" |
|
491 days ago |
This ones a keeper Charlie. -- Bruce from Central New York |
|
491 days ago |
Miles, you’re right about the fractions never quite being right. But I guess the applications I had in mind making the chart were more of the “in the ball park” variety. For example, I’m installing some hinges that came with screws, and the instructions say to drill 4mm pilot holes. If my bits are all fractional, what good is a decimal equivalent unless I have the corresponding bit size committed to memory. With the chart, I can look and see that 11/64 will do just fine. -- Charlie M. "Woodworking - patience = firewood" |
|
491 days ago |
Charlie did you know that Excel is just a knock off the on original Visicalc that came out when Bill Gates was teething. <vbg> Bob -- A mind, like a home, is furnished by its owner |
|
491 days ago |
Thank you Charlie It’s a good conversion table even for me….a Metric guy :-) Working in aviation for 36 years, I’m used to work with English because…...Boeing makes the airplanes in Inches, Feet and Knots but in my “civil” life, I work always with metric…well, living in metric countries… I can use this chart when I’m adding text to my pictures so they will be “Bilingual” (I’m posting in Australian, 2 Italian, 2 UK, Canadian, a few US and Brazilian forums). What “Kills” me in the English measuring system is that, on my rulers and measuring tapes, the beginning is 32 or even 64th but later it becomes 16th so, if I need to measure, say, 10-5/64, I don’t see it there. Another “killer” for me is that, if I want to measure, say, 10¾”, it’s also not written there…I have to convert it to 12/16” and look for the lines…. If you were using everything in say, 32nds or 16th – like 28/32” or 4/16” it would be much easier for me to measure….well, I believe that for you guys it comes natural… Regards |
|
491 days ago |
Niki, I’m not quite sure I follow. On most rulers, the lines for different increments are different lengths. For example, the longest lines between inches are often the ones that are 1/4” apart. So if you want to mark something at 10 3/4, you look for the 10, then count 3 long lines over. I guess it does seem more natural if you’ve been doing it that way all your life. Bob #2, I didn’t know that. And I’m going to pretend I’m too young to have ever seen an 8” floppy. :-) -- Charlie M. "Woodworking - patience = firewood" |
|
491 days ago |
Thanks. Lets see where else metric can help… How many hours are in a metric day? How many months in a metric year? Not everything is based on tens. Woodworking in inches makes sense when you contemplate the width of a standard blade kerf. Think about it. -- making sawdust.... |
|
491 days ago |
Hi Charlie Yeh, that’s what happens when I talk without pics :-) On the pic below, you can see that, up to 6” the graduation is 32 and from 6” – 16 so how I’m going to measure 10-5/64” but…maybe on your tapes you have a better graduation that this “bilingual” one :-) And than I have to count too many lines and not only but if I have to measure 5-3/8”, I have to “translate” it to 5-12/32” so, I’m writing (or reading) one number (5-3/8”) and measuring different number (5-12/32”) and that’s a little bit confusing if I’ll compare it to the Metric that I write, read and measure the same number. I’m sure that for you it comes much more natural but for a “non-native English measuring system” it’s a bit of confusing… Now, let me give you a compliment….look at the ruler below the tape – it’s made by “General” and it’s “Made in USA”- I have it since 1965 and after 43 years it looks as new as it was….well, when the thinks were “Made in USA”..... Regards |
|
491 days ago |
I understand now what you were saying, Niki. Different rulers are designed for different purposes, and so there are many different ways of marking the graduations. But think about this… A millimeter is much larger than 1/64, so if you wanted to measure something in millimeters as precisely as 10 5/64, that metric tape would not be too accurate either. -- Charlie M. "Woodworking - patience = firewood" |
|
491 days ago |
Hi Charlie I’m only an amateur but for the last 13 years I never had to measure or cut less than 1mm…(I also cannot see less that 1mm…getting 64… :-) ) Maybe we (I mean – Americans and Europeans) have different thinking. I did not see Metric plan calling for xx.5mm or xx.25mm…everything is given in full millimeters. Usually, I plan the cabinets dimensions myself (with general dimensions given by my wife – the designer) and I plan it down to 1mm. I don’t think that you’ll have a problem to plan a cabinet with all the dimensions down to /32” or even /16” The only time that I have to measure less than 1mm is when…..I align my table saw blade with the caliper… :) Best Regards |
|
491 days ago |
Niki, I’m lucky if I can cut a board to within 1/16th of what I want. :-) -- Charlie M. "Woodworking - patience = firewood" |
|
490 days ago |
There are quite a few examples in woodworking where we do indeed need to be more precise than nearest 1/64th or millimeter. Lets say you want to divide a 62 inch space into 45 equal increments. Or if you’re metric you round off that dimension to 1575 mm and divide by 45 equal increments. Either way, for purposes of accurate math calculations, you’re going to have to convert both systems to decimal places far more accurate than a millimeter or 64th to avoid arriving at an answer that is not just off, but considerably off. Just because a minute measurement is not visible on our rulers doesn’t mean they don’t play a crucial role in the math involved in our work. By the way, theres a name in woodworking for less than a millimeter or 1/64th. Depending on geographic location, it would either be a “smidgen” or a “hair”. Lol -- miles125, Alabama.."Architecture is frozen music"" |
|
490 days ago |
Miles, you’re absolutlely right. But I think we’re talking about 2 different things. For planning purposes, we need to be very precise. The example you give is a good one. But once you do the math, say you want to cut 45 pieces of wood that will fill a 62” space. The math tells you that each piece should be 1.37777777777 inches long. But in real life, if you manage to cut all 45 pieces within 1/64th of that figure, you are doing about as good as you can hope to do, in my opinion. Try to put those 45 pieces end to end and have them total 62”. I’ll bet a rusty block plane that you’ll either be a hair short or you’ll have to get out the sandpaper. So my point was that, for the purpose of measuring and marking a cut line, 1/64th is more than close enough. -- Charlie M. "Woodworking - patience = firewood" |
|
487 days ago |
you can use long ruler diagonally to get better accuracy (the same trick used for spacing dovetails). i have several rulers with 0.5mm markings on them, and i agree with niki – you cant see them or use them – they are just annoying. i find that i have better accuracy trying to mark in the middle of 1mm segment than trying to count the 0.5mm and mark on the right one. -- The woods are lovely, dark and deep, but I have promises to keep... |
|
487 days ago |
I have a Starrett Digital Tape Measure (which I damaged so I haven’t Anyhow, the Starrett tape will do all three and it will convert and allow -- Would you like to recession-proof your present business using the internet? - my revealing 9-page free report gives you the straight facts: http://copymatch.com/rec/cap.html |
|
486 days ago |
Easy way out Charlie, just use millimetres. LOL -- Grumpy - "Always look on the bright side of life"- Monty Python |
|
486 days ago |
Ya know, Grumpy, I’d be perfectly willing to go along with the whole metric deal if we could just change everything and not be stuck dealing with two systems. -- Charlie M. "Woodworking - patience = firewood" |
|
486 days ago |
What Charlie said! Bob -- A mind, like a home, is furnished by its owner |
|
485 days ago |
Charlie, The conversion part is not too bad. It’s the thinking in metric thats the hardest. Like thinking gas per litre as against per gallon. -- Grumpy - "Always look on the bright side of life"- Monty Python |
|
478 days ago |
Thanks Charlie, I can use this. Terry -- Terry Roswell, L.A. (Lower Alabama) "Life is what happens to you when you are making other plans." |
|
474 days ago |
Great chart, thanks – I love Excel for this stuff. I have a set of calipers that do inches and MM and I’d be lost without them. I use them all the time when trying to find a fractional drill bit that’s ‘close enough’ for my pen tubes! -- Tim D. - Woodstock, GA |
|
474 days ago |
Wow charlie this is great!!! I have needed something like this for a very long time. Great! it is going right up to my shop! -- Allison, Northeastern Ca. Remember, Amateurs built the Ark. Professionals built the Titanic! |
|
474 days ago |
Glad to have been of service! -- Charlie M. "Woodworking - patience = firewood" |
|
474 days ago |
Thank you so much!!!! I’ve been working on a sketchup plan for a kayak I’m hoping to build soon, and all the plan dimensions are in mm’s, this is a HUGE help. Thanks! -- Ryno |
|
23 days ago |
Where did you learn Math Charlie? I checked your chart out.. 1/4 of an inch is .25!!!!! not .2362!!! After seeing that one conversion. I wondered where you learned how to add? |
|
23 days ago |
Mondo, how in the world did you arrive at that? If you read Charlie’s chart it says that 6mm equals 0.2362 inches and that the nearest fraction of an inch is 1/4. It does not say that 1/4 inch is equal to 0.2362!!!! After seeing your comment, I wondered where you learned to read a table. -- Until you spread your wings, you'll have no idea how far you can walk. |
|
23 days ago |
Hey Guys, I’ve been using this chart for a while, I call it close enough for government work!!!! http://www.penn-union.com/ref%20material/Millimeter%20Decimal%20Fraction%20Conversion%20Chart.pdf I downloaded it along time ago and have by my drill press on the wall along with this chart. http://www.csgnetwork.com/drillsizeconvert.html -- Easy Peasy Lemon Squeezy-May all your dovetails fit tight and right the first time |
|
23 days ago |
The Metric measurement System was adopted by the United States as the ONLY legal method of measurement in the United States way back in the 1800’s (early I believe ) where it was made into Law. -- Roger, Rep. of Texas |
|
23 days ago |
Yeah, but I’ll use 1/8 meter if i want to, you can’t do anything about it ;-)) -- Debt is nothing more than the 21st Century's form of slavery. |
|
22 days ago |
Hey Topamax, How are you doing? -- Roger, Rep. of Texas |
|
22 days ago |
Why convert? If you’re uisng metric, use metric, forget the conversion, it’s easier than moving back and forth. Anyways, i read a while back why railroad tracks are the width they are. It goes all the way back to the width of 2 Roman Chariot pulling horses behinds. The wheels had to be so with to accomodate 2 horses, but no wider than necessary. The history went up through the ages of all the inventions that were based on the previous item. It all made sense as they progressed. Anyway, i still like my fractions for meters:-)) It keeps one’s math skills sharp; ie, 1/8 meter = 12.5 cm or 125 mm, right ? -- Debt is nothing more than the 21st Century's form of slavery. |
|
22 days ago |
Just in case -- Roger, Rep. of Texas |
|
22 days ago |
Hey Topamax, -- Roger, Rep. of Texas |
|
22 days ago |
so what do we do with the c… hair ? -- david ,new mexico ,allheart |
|
22 days ago |
Hey david, what are you doing up so late? – you must be converting inch fractions to millimeters. lol -- Roger, Rep. of Texas |
|
22 days ago |
Nicely done! Easy to read… Printed and hung on my shop wall. -- - Please help keep Lumberjocks an enjoyable escape by refusing to participate in political discussions. Simply spit out the bait and ignore the thread... |
|
22 days ago |
not up till late , -- david ,new mexico ,allheart |
|
22 days ago |
Thanks Charlie. -- Gene |
|
22 days ago |
Dave, thanks for defending my honor. :-) Mondo, the purpose of the chart is to start with a millimeter measurement and give the closest fractional equivalent. In the case of 6mm, you’d have to get into 128ths or beyond to get closer than 1/4. -- Charlie M. "Woodworking - patience = firewood" |
|
22 days ago |
Charlie, Etc. lol -- Roger, Rep. of Texas |
|
22 days ago |
Thanks Charlie -- Jim from Heirloom Woodshop Southern Oregon |
|
22 days ago |
Speaking of hair… there are three hair measurements: H, CH, and RCH. If any of you do not know what these abbreviations stand for, I will not be providing any further clarification. :-) -- Charlie M. "Woodworking - patience = firewood" |
|
22 days ago |
I use a digital caliper that will switch from fractional to decimal or metric with a push of a button. Don’t recall where I got it, but I use it all the time. -- Roy L, Arizona |
|
22 days ago |
Charlie, did you every think you would open such a discussion on your forum? LOL. Roger you forgot one: “Close enough for Goverment work”! -- John @ Myrtle Beach |
|
22 days ago |
Huff and Charlie, Have fun and take care -- Roger, Rep. of Texas |
|
22 days ago |
Nice chart Charlie!! Great work. Sorry i messed up your thread making wise cracks about using a fraction of a meter ;-)) You guys still missed the 2 most important units of measure the old time gunsmiths used in the 19th century: a trifle and a scoche. -- Debt is nothing more than the 21st Century's form of slavery. |
|
22 days ago |
It’s the same as a foreign language – as long as you have to translate everything to your prime language, you will never be comfortable. If someone tells me a widget is 32 cm long, I have no clue whether it is 1” or 20”. I have to say, “ok, 2.54 cm per inch, 32/2.54 – oh shit, where is my calculator. OK, 32/2=16, 32/3=~11, so it must be about 13-1/2””. Having been in the Navy, I did use the metric system some but never enough so I became comfortable with it. Same thing with km – I know it is 1000M, and since a meter is 39.36 inches, which is about a yard, 1KM is about 1000 yards, which is about 2/3 mile. Weight is even worse – 454 grams per pound… uh, what’s an ounce? What do you use when cooking – what’s a cup or teaspoon in metric??? I have no idea! I agree that we should fully adopt the metric system for its preciseness but don’t see it happening any time in my lifetime. |
|
22 days ago |
I would not suggest to convert Metric to English for any job that requires measuring…. An Inch will never convert round to mm and a mm will never convert round to Inch… Just a small example 1/2” = 12.7mm…..we don’t have any means to measure .7mm (the best ruler will have a graduations of .5mm that is very difficult to see and usually we work in whole mm unless it’s for NASA and they also work in metric) Another one, 13mm = 65.511811/128” that you can not read anywhere and you shall have to round it to 65/128” (if you can see it and if it’s practical) I think that the accumulative “left overs” will lead to a big mistake at the end of work…the best is to stick to the plan measurements, be it Metric or English… Jim As for volume, the smallest unit is Milliliter…(1000ml = 1 Liter)...the next is CC (Cubic Centimeter – used usually for car engine volume) As you can see, the pattern is constant for weight, volume and distance and it goes – Milli – Centi – Deci and Kilo….we start with the smallest unit and always multiply by 10 to get the next size unit (but, I’m sure that you know all that)...even though, the woodworkers are using only mm and it sounds very funny (even to me) that the cabinet length is 3,450mm instead of 3.45 Meters… But, if you are used to the English system and live in a country that almost everything is English, I’m sure that it will be easier for you to think and work in English measuring system….I also would not change my Metric even if the English is easier. BTW, in Europe, there are at least two things that are measured in English – the iron pipe diameter (the plastic ones are measured in mm) is measured in “Zall” (Tsall) and the TV screen is also measured in Inches… Best Regards |
|
22 days ago |
Don’t GARA which system is used. Just make a router bit that will cut a dado in which a standard piece of plywood will fit. Yeah, I know about jigs but, why do we have to use them? I cant even use my stacked dado blades, with or without shims, to get a groove(with one cut) for anything but BB plywood. -- Gene |
|
22 days ago |
If materials were standard sized like they used to be, the CEO bonuses would have to go back to those standards too :-)) -- Debt is nothing more than the 21st Century's form of slavery. |
|
You must be signed in to reply.
|
|
| Forum | Topics |
|---|---|
Woodworking Skill Share
|
2897 |
Woodworking Tools, Hardware and Accessories
|
3909 |
Safety in the Woodworking Shop
|
255 |
Designing Woodworking Projects
|
940 |
Sweating for Bucks Through Woodworking
|
220 |
Woodworking Trade & Swap
|
617 |
Coffee Lounge
|
2362 |
LumberJocks.com Site Feedback
|
522 |




























































