Degrees, Minutes & Seconds Conversion

[F51]

I am constantly having to convert lats & longs from degrees, minutes, seconds to degrees, minutes & decimal minutes or just decimal degrees. I am looking for an excel spreadsheet that will handle these conversions both ways. Any ideas? Thanks.

[Stu Jackson]

Yes, just make one up. 1/60, 2/60, 3/60...

[El Pinguino]

Why do you need a spread sheet? just divide by 6 in your head.... 36" = .6' , 40" =.66'
Same when going from minutes to decimal degrees.

[libramax]

Seems like it should be fairly easy to set up a small spreadsheet with the formulas in Excel. You will need one set of formulas for each input that you want to convert.

If you have an i-device, there seem to be a few converters that do it all on one screen. Here is one for example (not affiliated, just googled it): https://itunes.apple.com/us/app/coor...converter-free

[MBWhite]

Here's a free one that should do what you want:

http://www.softpedia.com/get/Office-...lculator.shtml

[StuM]

Or on Android :https://play.google.com/store/apps/d...CalcPlus&hl=en

does it very easily.

[clownfishsydney]

Or change your GPS to degrees-minutes-seconds, enter everything you need to enter, then change back to degrees-minutes-decimal minutes. Everything you enter will be converted perfectly.

[El Pinguino]

Has everybody really lost the ability to divide numbers under 60 by 6? And to multiply numbers by 6 when going the other way? ...OK that's harder - you have to shift the decimal point or something.

As I recall its the '6 times table' - memorised by rote in about year 4 or so.

Mind you they say that nobody on supermarket checkouts can make change without the help of electronics anymore........ sob

[conachair]

With Google Chrome open on Google home page or google search app, just say OK google 39 divided by 60...
She's got a rather nice English voice over here..
Then try ok Google beam me up scotty...

[meirriba]

Originally Posted by F51

I am constantly having to convert lats & longs from degrees, minutes, seconds to degrees, minutes & decimal minutes or just decimal degrees.

May I ask why?
Can 't you align your data/uses to a single system?

[achil]

Originally Posted by El Pinguino

Why do you need a spread sheet? just divide by 6 in your head.... 36" = .6' , 40" =.66'
Same when going from minutes to decimal degrees.

You do mean divide it by 60, don't you? If you divide 36/6 you end up with 6 not .6

[El Pinguino]

Originally Posted by achil

You do mean divide it by 60, don't you? If you divide 36/6 you end up with 6 not .6

I guess so... but I just divide by six and shift the dot thingo to the left automatically...6 into 36 and shift the dot thingo is easier than 60 into 36

[CLady]

This seems to be an engineer, or wanna be engineer, setting up an EXCEL spreadsheet to convert minutes and seconds like this. Dividing by 6 or multiplying by 6 is good. Hmmm, does he perhaps have a mechanical pencil tucked neatly in a vinyl pocket protector inserted in his short-sleeved dress shirt breast pocket?

[CLady]

Oooops! Divide by 60, not 6, and 'show your work'! Otherwise, you won't see the ways of your errors!

[El Pinguino]

Mechanical pencils were cool. I had one about 1956 but someone nicked it.
However I did find a 4 colour 'biro' behind the washing machine the other day...probly been there 15 years or so.

Whats rong with doing the simple stuff in your head?

I do lots of stuff in my head... which is a bit of a worry......and a little bit scary