How to format Excel to add geo coordinates

July 9, 2011 at 07:45:11
Specs: Windows 7
In geocaching we use geographic coordinates in the format DDD MM,mmm where DDD are degrees (0-180), MM are minutes (0-60) and mmm are decimals.

Is there a way to format cells in Excel to insert coordinates in that format and do operations on them ?

I understand that [HH] could be used to represent degrees but how do I use minutes with decimals ?

I basically need a way to Input coordinates like N 45 23.888 and add 42.000 minutes so that it returns N 46 05.888


See More: How to format Excel to add geo coordinates

Report •

July 9, 2011 at 12:53:16
Look here, it should give you a start:


Report •

July 9, 2011 at 16:23:13
Ok. It's not exactly what I was looking for but I was able to convert my DDD MM,mmm coordinates to DDD,ddddd. It then easy to add or substract coordinates. I then convert them back to DDD MM,mmm format...

Thanks for the help !

Report •

Related Solutions

Ask Question