+ Reply to Thread
Results 1 to 2 of 2

Measuring distance between LAT/LONGs

  1. #1
    Registered User
    Join Date
    11-21-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Measuring distance between LAT/LONGs

    Is it possible to use a formula to calculate the distance between two latitude/longitude points? My format right now is DMS (ex 123456N 1234567E), but I could convert to DD if necessary. I'd need a variety of measures, including Mike's, kilometers, and nautical miles. I can post an example of it helps. Thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Measuring distance between LAT/LONGs

    Please Login or Register  to view this content.
    The coordinates need to be in decimal degrees, positive for north latitudes and east longitudes.

    Multiply the result by earth radius in whatever units you prefer.
    Last edited by shg; 07-26-2016 at 06:05 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lats Longs Easting Northing Conversions
    By Knawl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2015, 05:34 AM
  2. Geofencing Lat / Longs (Finding Closest Point) in Excel
    By mattkunkle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 02:05 PM
  3. Dictionary can't handle Longs > 10,000,000?
    By R Avery in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2010, 09:21 PM
  4. convert lat/longs
    By batorizer in forum Excel General
    Replies: 9
    Last Post: 01-09-2009, 03:52 PM
  5. Convert Lats and longs to decimals
    By dharmik in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2006, 02:55 PM
  6. convert lats and longs to decimals
    By dharmik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2006, 02:12 PM
  7. Replies: 0
    Last Post: 08-25-2005, 02:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1