ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula for longitude/latitude (https://www.excelbanter.com/excel-discussion-misc-queries/29143-formula-longitude-latitude.html)

Leo

formula for longitude/latitude
 
any one know where one can get a formula that will parse x,y coordinates from
degrees/minutes/seconds into decimal ?

Niek Otten

Maybe this one?

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Leo" wrote in message
...
any one know where one can get a formula that will parse x,y coordinates
from
degrees/minutes/seconds into decimal ?




Peo Sjoblom

See:

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


Regards,

Peo Sjoblom

"Leo" wrote:

any one know where one can get a formula that will parse x,y coordinates from
degrees/minutes/seconds into decimal ?



All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com