| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distance calculator from longitude and latitude | Excel Discussion (Misc queries) | |||
| Formating Longitude and Latitude | Excel Worksheet Functions | |||
| Converting numbers to longitude and latitude | Excel Worksheet Functions | |||
| formula for longitude/latitude | Excel Discussion (Misc queries) | |||
| Help with Latitude and Longitude. | New Users to Excel | |||
Linear Mode
