Formatting Latitude/Longitude
 

I have been trying to figure out some data I have been trying to incorporate
into a time/distance calculator I am working on. I have a data set with
airports that is formatted in degrees. I have a second data set I pulled
out of an older planning program. It is the information for Air Refueling
tracks. Each track has two points begin/end. The format was different
and is now not making sense to me. If you can see in the data sample I've
included, a couple of the coordinates have 60 as the seconds?? Does that
make sense? I am trying to format all of these into decimal degrees, then
radians to work with my sheet. I can send the text to columns, but after
that I am a little lost with this format. I will send the file I am working
with also. I appreciate any help you can give.







019S 0423660N 1003830W 0392600N 0993860W 19S

020NE 0434930N 0660457W 0460912N 0603210W 2NE

020SW 0460912N 0600321W 0434930N 0660457W 2SW

Formatting Latitude/Longitude
 

You might get something usable from Chip Pearson's site.

http://www.cpearson.com/excel/latlong.aspx


Gord Dibben MS Excel MVP

On Wed, 14 Oct 2009 17:48:31 -0500, "Mike and Cheryl Tindall"
wrote:

I have been trying to figure out some data I have been trying to incorporate
into a time/distance calculator I am working on. I have a data set with
airports that is formatted in degrees. I have a second data set I pulled
out of an older planning program. It is the information for Air Refueling
tracks. Each track has two points begin/end. The format was different
and is now not making sense to me. If you can see in the data sample I've
included, a couple of the coordinates have 60 as the seconds?? Does that
make sense? I am trying to format all of these into decimal degrees, then
radians to work with my sheet. I can send the text to columns, but after
that I am a little lost with this format. I will send the file I am working
with also. I appreciate any help you can give.







019S 0423660N 1003830W 0392600N 0993860W 19S

020NE 0434930N 0660457W 0460912N 0603210W 2NE

020SW 0460912N 0600321W 0434930N 0660457W 2SW