LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
morchard
 
Posts: n/a
Default Determining Distance from Latitude and Longitude


Is there a formula for deriving the great circle distance between two
points on the earth's surface when you have their latitude and
longitude?

The format I have the latitude/longitude in is:
Latitude Longitude
017/025S 145/030W
026/045S 141/000E
031/008N 033/048E
036/050N 008/000E


--
morchard
------------------------------------------------------------------------
morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=489407

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you change Longitude and Latitude from degrees to decimal Hurley Excel Discussion (Misc queries) 1 September 30th 05 05:04 PM
Formating Latitude and Longitude co-ordinates Tomas Excel Discussion (Misc queries) 1 June 29th 05 12:55 AM
Can distance be calculated using latitude and longitude? Paxton Excel Worksheet Functions 1 May 2nd 05 02:34 PM
Distance between zip codes Squid Excel Worksheet Functions 2 March 10th 05 04:27 AM
Help with Latitude and Longitude. LadiFireBug New Users to Excel 1 January 22nd 05 08:54 AM


All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"