ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Latitude and Longitde problem (https://www.excelbanter.com/excel-discussion-misc-queries/61933-latitude-longitde-problem.html)

Francois Ashton

Latitude and Longitde problem
 
Hi all

Just wondering if somebody can help me with a problem.

I need to calculate the distance between two latitude and longitude
co-ordinates. Is there a function I can use? The lat. and long.
co-ordinates are expressed as decmals and not deg, mins and secs.

Any help will be appreciated.

Thanks

Francois



Bernard Liengme

Latitude and Longitde problem
 
see www.cpearson.com where Chips has lots on lat & long.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Francois Ashton" wrote in message
...
Hi all

Just wondering if somebody can help me with a problem.

I need to calculate the distance between two latitude and longitude
co-ordinates. Is there a function I can use? The lat. and long.
co-ordinates are expressed as decmals and not deg, mins and secs.

Any help will be appreciated.

Thanks

Francois




Gary''s Student

Latitude and Longitde problem
 
See:
http://www.movable-type.co.uk/scripts/LatLong.html
--
Gary''s Student


"Bernard Liengme" wrote:

see www.cpearson.com where Chips has lots on lat & long.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Francois Ashton" wrote in message
...
Hi all

Just wondering if somebody can help me with a problem.

I need to calculate the distance between two latitude and longitude
co-ordinates. Is there a function I can use? The lat. and long.
co-ordinates are expressed as decmals and not deg, mins and secs.

Any help will be appreciated.

Thanks

Francois





Francois Ashton

Latitude and Longitde problem
 
Many thanks

Went there and seem to have found a solution.

Help is appreciated.

Francois

"Bernard Liengme" wrote in message
...
see www.cpearson.com where Chips has lots on lat & long.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Francois Ashton" wrote in message
...
Hi all

Just wondering if somebody can help me with a problem.

I need to calculate the distance between two latitude and longitude
co-ordinates. Is there a function I can use? The lat. and long.
co-ordinates are expressed as decmals and not deg, mins and secs.

Any help will be appreciated.

Thanks

Francois







All times are GMT +1. The time now is 10:09 PM.

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