DiscoDunc
Member Since: 08 May 2006
Location: Bristol
Posts: 16390
![](templates/vbnew/images/spacer.gif)
![2010 Discovery 4 3.0 SDV6 HSE Auto Aintree Green 2010 Discovery 4 3.0 SDV6 HSE Auto Aintree Green](../images/veh/aintree_green.gif)
|
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 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
|
12th May 2009 12:46 pm |
|
|
SJR
Member Since: 09 Aug 2006
Location: East Manchester
Posts: 4030
![](templates/vbnew/images/spacer.gif)
![2006 Discovery 3 TDV6 SE Auto Arctic Frost 2006 Discovery 3 TDV6 SE Auto Arctic Frost](../images/veh/arctic_frost.gif)
|
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 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 -
|
12th May 2009 12:50 pm |
|
|
|
TazDaz
Member Since: 07 May 2007
Location: South East Essex
Posts: 2858
![](templates/vbnew/images/spacer.gif)
|
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
|
12th May 2009 1:41 pm |
|
|
DiscoDunc
Member Since: 08 May 2006
Location: Bristol
Posts: 16390
![](templates/vbnew/images/spacer.gif)
![2010 Discovery 4 3.0 SDV6 HSE Auto Aintree Green 2010 Discovery 4 3.0 SDV6 HSE Auto Aintree Green](../images/veh/aintree_green.gif)
|
thanks guys
i had tried the multiply by 60 business but the locations were miles out - that could have been my calcs though
tazdaz , i'll give that a go
EDIT
Thanks tazdaz it works a treat 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
|
12th May 2009 2:24 pm |
|
|
tyke65
Member Since: 18 Nov 2007
Location: God's Country
Posts: 130
![](templates/vbnew/images/spacer.gif)
![2006 Discovery 3 TDV6 S Auto Zermatt Silver 2006 Discovery 3 TDV6 S Auto Zermatt Silver](../images/veh/zermatt_silver.gif)
|
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.
|
14th May 2009 7:06 am |
|
|
|