Advertise on DISCO4.COM
Forum · Gallery · Wiki · Shop · Sponsors
DISCO4.COM > In Car Electronics (D3)

GPS - converting decimal GPS to d/m/s
Post Reply  Down to end
Page 1 of 1
DiscoDunc
 


Member Since: 08 May 2006
Location: Bristol
Posts: 16390

England 2010 Discovery 4 3.0 SDV6 HSE Auto Aintree GreenDiscovery 4
GPS - converting decimal GPS to d/m/s

Can anyone help with an excel formula please that can convert decimal GPS ie 44.1212 2.4567 to degrees, minutes and seconds.

I have about 100 entries for French and Spanish campsites in an excel spreadsheet that I need to convert.

Many Thanks Thumbs Up
 Duncan
-----------------------------------------------------
If I'd known I was going to be so thirsty this morning I'd have drunk more beer last night.
FFRR Autobiography 4.4 SDV8 MY17
D4 HSE MY13 SOLD
FFRR 3.6 Vogue TDV8 SOLD
D4 HSE MY10 SOLD
D4 SE TECH MY15 SOLD
D4 XS MY12 SOLD
D4 HSE MY10 SOLD
D3 HSE MY06 - Re-Cycled Worldwide 
 
Post #46601712th May 2009 12:46 pm
View user's profile Send private message View poster's gallery Reply with quote
SJR
 


Member Since: 09 Aug 2006
Location: East Manchester
Posts: 4030

England 2006 Discovery 3 TDV6 SE Auto Arctic FrostDiscovery 3

Quote:
How To Convert a Decimal to Sexagesimal

You'll often find degrees given in decimal degrees (121.135°) instead of the more common degrees, minutes, and seconds (121°8'6"). However, it's easy to convert from a decimal to the sexagesimal system.

Difficulty Level: average Time Required: 5 minutes

Here's How:

1. The whole units of degrees will remain the same (i.e. in 121.135° longitude, start with 121°).
2. Multiply the decimal by 60 (i.e. .135 * 60 = 8.1).
3. The whole number becomes the minutes (8').
4. Take the remaining decimal and multiply by 60. (i.e. .1 * 60 = 6).
5. The resulting number becomes the seconds (6"). Seconds can remain as a decimal.
6. Take your three sets of numbers and put them together, using the symbols for degrees (°), minutes (‘), and seconds (") (i.e. 121°8'6" longitude)

Tips:

1. You can choose between decimal degrees and degrees, minutes, and seconds on your GPS.
2. Once you have degrees, minutes, and seconds, it's often easier to find your location on most maps (especially topographic maps).
3. Though there are 360 degrees in a circle, each degree is divided into sixty minutes and each minute is divided into sixty seconds.


http://geography.about.com/library/howto/htdegrees.htm

Hope this helps Thumbs Up
 I believe that every human has a finite number of heart-beats. I don't intend to waste any of mine running around doing exercises.
Buzz Aldrin (1930 - 
 
Post #46602012th May 2009 12:50 pm
View user's profile Send private message View poster's gallery Reply with quote
Martin
Site Admin and Owner 


Member Since: 06 Nov 2004
Location: Hook Norton
Posts: 18456

United Kingdom 2006 Discovery 3 TDV6 SE Manual Buckingham BlueDiscovery 3

http://geography.about.com/library/howto/htdegrees.htm

http://www.google.co.uk/search?q=convert+d...es+seconds
  
Post #46602112th May 2009 12:51 pm
View user's profile Send private message View poster's gallery Send e-mail Reply with quote
TazDaz
 


Member Since: 07 May 2007
Location: South East Essex
Posts: 2858

United Kingdom 

if decimal degree is in cell A1 then ..

=INT(A1) (place in cell B1)
=INT((A1-INT(A1))*60) (place in cell C1)
=INT(((A1-INT(A1))*60-INT((A1-INT(A1))*60))*60) Place in cell D1

3 columns then give Deg - Min -Secs
  
Post #46605412th May 2009 1:41 pm
View user's profile Send private message View poster's gallery Reply with quote
DiscoDunc
 


Member Since: 08 May 2006
Location: Bristol
Posts: 16390

England 2010 Discovery 4 3.0 SDV6 HSE Auto Aintree GreenDiscovery 4

thanks guys Thumbs Up

i had tried the multiply by 60 business but the locations were miles out - that could have been my calcs though Embarassed

tazdaz Thumbs Up Thumbs Up , i'll give that a go

EDIT

Thanks tazdaz Thumbs Up it works a treat Bow down
 Duncan
-----------------------------------------------------
If I'd known I was going to be so thirsty this morning I'd have drunk more beer last night.
FFRR Autobiography 4.4 SDV8 MY17
D4 HSE MY13 SOLD
FFRR 3.6 Vogue TDV8 SOLD
D4 HSE MY10 SOLD
D4 SE TECH MY15 SOLD
D4 XS MY12 SOLD
D4 HSE MY10 SOLD
D3 HSE MY06 - Re-Cycled Worldwide 
 
Post #46607312th May 2009 2:24 pm
View user's profile Send private message View poster's gallery Reply with quote
tyke65
 


Member Since: 18 Nov 2007
Location: God's Country
Posts: 130

United Kingdom 2006 Discovery 3 TDV6 S Auto Zermatt SilverDiscovery 3

There's a web page that will do it for you:-

http://www.nearby.org.uk/coord.cgi?p=sh891506&f=conv

Also there's an Phone/Touch app that's a breeze to use called 'GB Locate'. It's free, as I remember.

They will convert between any type of grid reference.
 Just because you're paranoid doesn't mean that they're not out to get you.  
Post #46695514th May 2009 7:06 am
View user's profile Send private message View poster's gallery Reply with quote
bearman
 


Member Since: 04 Sep 2008
Location: East London
Posts: 49

South Africa 2012 Discovery 4 3.0 SDV6 SE Auto Nara BronzeDiscovery 4

Have a look here

http://www.4x4community.co.za/forum/showthread.php?t=24515
  
Post #46803616th May 2009 9:29 am
View user's profile Send private message View poster's gallery Post Reply
Display posts from the last:  
Post Reply Back to top
Page 1 of 1
Jump to:  
Previous Topic | Next Topic >


Posting Rules
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



DISCO4.COM Copyright © 2004-2024 Futuranet Ltd & Martin Lewis
DISCO3.CO.UK RSS Feed - All Forums

DISCO4.COM is independent and not affiliated to Land Rover.
Switch to Mobile Site