Converting degrees, minutes and seconds to decimal

 

I'm new to this site and to GPS in general. I have a Garmin Nuvi 200 and want to add some POI's. I went to Google Earth and found one of the locations and tried to convert Google's coordinates to decimal via a spreadsheet that I downloaded. The resulting decimal coordinates placed the location two or three miles north of where it should be.

Google's coordinates were:
32 50'02.65 N
97 10'50.73 W

In the spreadsheet, I entered the minutes as 50.02 and 10.50 because I got an error if I put in the ' symbol. I just don't know what I'm doing on this conversion. Can someone help?

Thanks

In google earth go to

In google earth go to "tools" "options" and change it to "decimal degrees".

http://i31.photobucket.com/albums/c361/bbapties/GE.jpg

Google Earth converts it for you.

Hope this helps! grin

Google earth gives you that

Google earth gives you that choice.

In GE, go to "Preferences" and you can select the format you want.

--
Nuvi 650 (SW 4.30; GPS SW 3.00) , GPSmap 60CSx (SW 3.50; GPS SW 3.00), GPS III Plus

Basically Google Earth. Just

Basically Google Earth. Just hit Satellite. Fun to play with

Here's what it should look like

-97.105073 in Col A of your Excel Spreadsheet
32.500265 in Col B
Col C can have a Description
Col D I use for the address

Download one of the CSV POI's from here and you will see how they are done.

--
Larry - Nuvi 680, Nuvi 1690, Nuvi 2797LMT

use this website to convert

use this website to convert http://www.gpsvisualizer.com/calculators

or when looking at the location in google earth, you can highlight it and if you are using the new version you can click on the properties and it will give you the longitude and latitude in the correct format.

Miss POI

Thanks

grin

Well, that makes it pretty easy! Thank you very much!

If converting with a spreadsheet

williea wrote:

I'm new to this site and to GPS in general. I have a Garmin Nuvi 200 and want to add some POI's. I went to Google Earth and found one of the locations and tried to convert Google's coordinates to decimal via a spreadsheet that I downloaded. The resulting decimal coordinates placed the location two or three miles north of where it should be.

Google's coordinates were:
32 50'02.65 N
97 10'50.73 W

In the spreadsheet, I entered the minutes as 50.02 and 10.50 because I got an error if I put in the ' symbol. I just don't know what I'm doing on this conversion. Can someone help?

Thanks

If converting with a spreadsheet, the location is the degrees + (Minutes/60) + (Seconds/3600). Longitude is negative in W.

--
Garmin StreetPilot c530, Mapsource