• Welcome to MacSailing.net!
  • Dedicated to sailing!
  • Be Jolly!
Hello There, Guest! Login Register

MacSailing.net > MacSailing.net > MacENC & GPSNavX > GPSBable >

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Title: GPSBable
Offline
Jade
5


******
Posts: 769
Threads: 15
Joined: May 14, 2005
Reputation: 4
#4
February 10, 2010 08:14
If you decide to use Excel, this formula will convert Latitudes (ddº mm.mmm' N) in cell A1 to decimal format (±nn.nnnnn)

=(LEFT(A1,2)*1+MID(A1,5,6)/60)*IF(RIGHT(A1,1) = "N",1,-1)

and for Longitudes (dddº mm.mmm' W) in cell A2:

=(LEFT(A2,3)*1+MID(A2,6,6)/60)*IF(RIGHT(A2,1) = "E",1,-1)
— —•••  •••— —
 Jon Longworth

 
Reply
  


Messages In This Thread
[No subject] - by - February 8, 2010 09:09
[No subject] - by - February 8, 2010 09:14
[No subject] - by - February 9, 2010 20:30
[No subject] - by - February 10, 2010 08:14
[No subject] - by - February 10, 2010 20:21
[No subject] - by - February 11, 2010 06:35
[No subject] - by - February 24, 2010 16:47
[No subject] - by - March 4, 2010 09:29
[No subject] - by - March 4, 2010 12:14
[No subject] - by - March 5, 2010 07:56

Forum Jump:


Browsing: 2 Guest(s)