Distance between GPS points (Decimal degrees)

#1 February 1st 05, 05:05 PM

Does anyone have a function created in Excel to calculate the distance
between two GPS points which are in decimal degrees?

#2 February 2nd 05, 01:55 AM

I vaguely remember that Chip Pearson has some formulas for this sort of thing.
Try searching as www.cpearson.com

On Tue, 1 Feb 2005 09:05:03 -0800, "David Reavill" <David
> wrote:

>Does anyone have a function created in Excel to calculate the distance
>between two GPS points which are in decimal degrees?

#3 February 2nd 05, 04:12 PM

The formula is at www.cpearson.com/excel/latlong.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Myrna Larson" > wrote in
message ...
>I vaguely remember that Chip Pearson has some formulas for this
>sort of thing.
> Try searching as www.cpearson.com
>
> On Tue, 1 Feb 2005 09:05:03 -0800, "David Reavill" <David
> > wrote:
>
>>Does anyone have a function created in Excel to calculate the
>>distance
>>between two GPS points which are in decimal degrees?
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
all the cells in excell put 2 decimal points in all numbers no ma.	carroll616	Excel Discussion (Misc queries)	4	December 1st 05 04:01 AM
How do I override fixed decimal place settings in EXcel 2003?	jroyv	Excel Worksheet Functions	2	February 11th 05 06:07 PM
division and decimal points	Paul K.	Excel Worksheet Functions	9	January 26th 05 08:13 PM
Newbie to charts question - projecting values between data points	38N90W	Excel Discussion (Misc queries)	3	January 6th 05 05:15 AM
converting from digital degrees to degrees minutes seconds	Patricio Boric	Excel Worksheet Functions	1	November 28th 04 07:43 PM