M
Mike and Cheryl Tindall
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
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