LumberJocks

Converting Millimeters to Fractions

  • Advertise with us

« back to Woodworking Skill Share forum

Forum topic by CharlieM1958 posted 2196 days ago 34805 views 10 times favorited 107 replies Add to Favorites Watch
View CharlieM1958's profile

CharlieM1958

15651 posts in 2815 days


2196 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"


107 replies so far

View Russel's profile

Russel

2199 posts in 2536 days


#1 posted 2196 days ago

Very cool. Thanks.

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

View lew's profile

lew

9938 posts in 2352 days


#2 posted 2196 days ago

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 2245 days


#3 posted 2196 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.

View Karson's profile

Karson

34853 posts in 2997 days


#4 posted 2196 days ago

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

15651 posts in 2815 days


#5 posted 2196 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"

View Bob N's profile

Bob N

131 posts in 2524 days


#6 posted 2196 days ago

Charlie,

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

View SteveKorz's profile

SteveKorz

2130 posts in 2311 days


#7 posted 2196 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) †

View Greg Wurst's profile

Greg Wurst

777 posts in 2429 days


#8 posted 2196 days ago

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 2371 days


#9 posted 2196 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 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

15651 posts in 2815 days


#10 posted 2196 days ago

LOL, MrWoody!

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

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

View GMman's profile

GMman

3902 posts in 2294 days


#11 posted 2196 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

View Zuki's profile

Zuki

1404 posts in 2674 days


#12 posted 2196 days ago

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 2264 days


#13 posted 2196 days ago

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

View Callum Kendall's profile

Callum Kendall

1918 posts in 2300 days


#14 posted 2196 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/

View Douglas Bordner's profile

Douglas Bordner

3960 posts in 2661 days


#15 posted 2196 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.

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