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

thanks.

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 !

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History