Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Rate Thread Display Modes
Old 05-12-2014, 10:07   #1
F51
Registered User

Join Date: Mar 2010
Posts: 235
Images: 5
Degrees, Minutes & Seconds Conversion

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.
__________________

__________________
F51 is offline   Reply With Quote
Old 05-12-2014, 10:14   #2
Registered User
 
Stu Jackson's Avatar

Join Date: Jan 2011
Location: Cowichan Bay, BC (Maple Bay Marina)
Posts: 6,385
Re: Degrees, Minutes & Seconds Conversion

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

__________________
Stu Jackson
Catalina 34 #224 (1986) C34IA Secretary
Cowichan Bay, BC, (Maple Bay Marina) SR/FK, M25, Rocna 10 (22#) (NZ model)
Stu Jackson is offline   Reply With Quote
Old 05-12-2014, 12:08   #3
Registered User
 
El Pinguino's Avatar

Join Date: Aug 2013
Location: Punta Arenas ahorra
Boat: 39' Westerly Sealord
Posts: 3,947
Re: Degrees, Minutes & Seconds Conversion

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.
El Pinguino is offline   Reply With Quote
Old 05-12-2014, 15:36   #4
Registered User

Join Date: Aug 2014
Boat: Wannabe 34 (BW of course)
Posts: 28
Re: Degrees, Minutes & Seconds Conversion

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

__________________
libramax is offline   Reply With Quote
Old 05-12-2014, 15:41   #5
Registered User
 
MBWhite's Avatar

Join Date: Apr 2012
Location: Illinois
Boat: Hurley Alacrity
Posts: 370
Re: Degrees, Minutes & Seconds Conversion

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

http://www.softpedia.com/get/Office-...lculator.shtml
__________________
MBWhite is offline   Reply With Quote
Old 05-12-2014, 22:06   #6
Senior Cruiser
 
StuM's Avatar

Cruisers Forum Supporter

Join Date: Nov 2013
Location: Port Moresby,Papua New Guinea
Boat: FP Belize Maestro 43
Posts: 6,709
Re: Degrees, Minutes & Seconds Conversion

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

does it very easily.
__________________
StuM is online now   Reply With Quote
Old 06-12-2014, 00:13   #7
Registered User
 
clownfishsydney's Avatar

Join Date: Mar 2014
Location: Sydney, Australia
Boat: Lightwave 38' Catamaran
Posts: 304
Re: Degrees, Minutes & Seconds Conversion

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.
__________________
Michael and Kelly
Catlypso - Web Site
Lightwave 38' cat
clownfishsydney is offline   Reply With Quote
Old 06-12-2014, 00:58   #8
Registered User
 
El Pinguino's Avatar

Join Date: Aug 2013
Location: Punta Arenas ahorra
Boat: 39' Westerly Sealord
Posts: 3,947
Re: Degrees, Minutes & Seconds Conversion

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
El Pinguino is offline   Reply With Quote
Old 06-12-2014, 02:16   #9
Registered User

Join Date: Nov 2007
Location: Probably in an anchorage or a boatyard..
Boat: Ebbtide 33' steel cutter
Posts: 3,537
Re: Degrees, Minutes & Seconds Conversion

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...
__________________
conachair is offline   Reply With Quote
Old 06-12-2014, 09:13   #10
Registered User

Join Date: Sep 2010
Location: Boat in Turkey, Beach cat in Israel
Boat: Lagoon 400 & Nacra 6.0 beach cat
Posts: 627
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by F51 View Post
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?
__________________
Mark, S/Y Bat-Yam
meirriba is offline   Reply With Quote
Old 06-12-2014, 14:21   #11
Registered User

Join Date: Jul 2013
Posts: 65
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by El Pinguino View Post
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
__________________
Pat.
achil is offline   Reply With Quote
Old 07-12-2014, 02:27   #12
Registered User
 
El Pinguino's Avatar

Join Date: Aug 2013
Location: Punta Arenas ahorra
Boat: 39' Westerly Sealord
Posts: 3,947
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by achil View Post
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
El Pinguino is offline   Reply With Quote
Old 10-12-2014, 02:33   #13
Senior Cruiser
 
CLady's Avatar

Cruisers Forum Supporter

Join Date: Jan 2013
Location: Seattle
Boat: C&C40T 1980
Posts: 180
Re: Degrees, Minutes & Seconds Conversion

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 is offline   Reply With Quote
Old 10-12-2014, 02:36   #14
Senior Cruiser
 
CLady's Avatar

Cruisers Forum Supporter

Join Date: Jan 2013
Location: Seattle
Boat: C&C40T 1980
Posts: 180
Re: Degrees, Minutes & Seconds Conversion

Oooops! Divide by 60, not 6, and 'show your work'! Otherwise, you won't see the ways of your errors!
__________________
CLady is offline   Reply With Quote
Old 10-12-2014, 02:45   #15
Registered User
 
El Pinguino's Avatar

Join Date: Aug 2013
Location: Punta Arenas ahorra
Boat: 39' Westerly Sealord
Posts: 3,947
Re: Degrees, Minutes & Seconds Conversion

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
__________________

El Pinguino is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lectrasan low voltage at 5 seconds wynmead Plumbing Systems and Fixtures 13 28-09-2013 15:15
Looking For A 12v Button That Will Close The Circuit For X Seconds rebel heart Electrical: Batteries, Generators & Solar 20 13-08-2012 09:45
120 Seconds fishwife Off Topic Forum 5 26-10-2010 10:10
ST6001+ Beeps Every 30 Seconds in Wind Vane Mode dubhouse Marine Electronics 1 12-05-2010 22:50
From 5 to 70 knots in less than 60 seconds Raven Seamanship & Boat Handling 17 01-08-2007 13:45



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -7. The time now is 01:58.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.