In from a colleague. Buy the book, or use the formula.
BW

>A number of years ago [Gary Fitzpatrick] compiled a volume called
>Direct-Line Distances which gave the distances between 1001 cities.
>Although this is still available from Scarecrow Press, it is woefully out
>of date in the sense that a large number of entries have changed names and
>countries. The distances, of course, are still valid.
>
>The formula for computing a great circle distance is not difficult.
>It can usually be found in any book on navigation, such as the
>American Practical Navigator. It should not be hard for you to write
>a program in Excel to quickly compute distances on demand.
>
>Here is the formula:
>
>Cos D = (sinA * sinB) + (cosA * cosB*cos DL)
>
>where
>
>A = lattiude of point A
>
>B = latitude of point B
>
>DL = difference in longitude between points A and B
>
>D = the great circle distance expressed in degrees between points A
>and B.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp