LumberJocks

Converting Millimeters to Fractions

  • Advertise with us

« back to Woodworking Skill Share forum

Forum topic by CharlieM1958 posted 07-18-2008 08:44 PM 35329 views 10 times favorited 107 replies Add to Favorites Watch
View CharlieM1958's profile

CharlieM1958

15695 posts in 2869 days


07-18-2008 08:44 PM

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"


107 replies so far

View Russel's profile

Russel

2199 posts in 2590 days


#1 posted 07-18-2008 08:50 PM

Very cool. Thanks.

-- Working at Woodworking http://www.VillageLaneFurniture.com

View lew's profile

lew

10024 posts in 2406 days


#2 posted 07-18-2008 08:57 PM

Thanks, Charlie!

This will be great laminated and hanging in the shop.

Lew

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View PurpLev's profile

PurpLev

8476 posts in 2299 days


#3 posted 07-18-2008 09:35 PM

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.

View Karson's profile

Karson

34874 posts in 3051 days


#4 posted 07-18-2008 09:40 PM

Thanks Charlie. Print out nice on the color laser.

-- I've been blessed with a father who liked to tinker in wood, and a wife who lets me tinker in wood. Southern Delaware karson_morrison@bigfoot.com †

View CharlieM1958's profile

CharlieM1958

15695 posts in 2869 days


#5 posted 07-18-2008 09:41 PM

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"

View Bob N's profile

Bob N

131 posts in 2578 days


#6 posted 07-18-2008 09:55 PM

Charlie,

I really apprciate your sharing this with us. This will come in soooo handy!

View SteveKorz's profile

SteveKorz

2131 posts in 2364 days


#7 posted 07-18-2008 09:57 PM

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) †

View Greg Wurst's profile

Greg Wurst

781 posts in 2483 days


#8 posted 07-18-2008 10:23 PM

That’s going in the shop. Thanks for the effort!

-- You're a unique and special person, just like everyone else.

View MrWoody's profile

MrWoody

305 posts in 2425 days


#9 posted 07-18-2008 10:49 PM

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 it’s in imperial measure use imperial. If it’s in metric use metric. The cost of appropiate measuring instruments is very low compared with the aggravation and inaccuracy of converting. Just the opinion of one ticked Canadian. It wasn’t broken and didn’t need fixing.

-- If we learn from our mistakes, I'm getting a fantastic education.

View CharlieM1958's profile

CharlieM1958

15695 posts in 2869 days


#10 posted 07-18-2008 10:54 PM

LOL, MrWoody!

I’ll try not to take it personally. :-)

-- Charlie M. "Woodworking - patience = firewood"

View GMman's profile

GMman

3902 posts in 2348 days


#11 posted 07-18-2008 11:08 PM

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

View Zuki's profile

Zuki

1404 posts in 2728 days


#12 posted 07-19-2008 12:39 AM

Thanks Charlie. I use both out in the shop. At time I find that metric is more accurate.

The chart is super.

-- BLOG - http://www.colorfulcanary.com/search/label/Zuki

View Rob 's profile

Rob

197 posts in 2318 days


#13 posted 07-19-2008 01:02 AM

It prints well in good ole b&w too. Thanks Charlie, great idea.

View Callum Kendall's profile

Callum Kendall

1918 posts in 2354 days


#14 posted 07-19-2008 01:03 AM

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/

View Douglas Bordner's profile

Douglas Bordner

3964 posts in 2714 days


#15 posted 07-19-2008 04:09 AM

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.

showing 1 through 15 of 107 replies

Have your say...

You must be signed in to reply.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com

Latest Projects | Latest Blog Entries | Latest Forum Topics

GardenTenders.com :: gardening showcase