2020 Archives by date, by thread · List index

# Re: [libreoffice-users] [Calc] Convert GPS coords from DMS to decimals?

```Would need more info on the format, but the following calculation
seems to work to convert the number part. Not sure of the N and
O, or how - (negative sign) in some work...

Did the following.
Put in Cell A1: 00°05'12"O 42°59'12"N -> 42.98666667,-0.08666667
In Cell B1: Put the Formula -
=VALUE(MID(A1,1,2))+VALUE(MID(A1,4,2))/60+VALUE(MID(A1,7,2))/3600
That gives result of 0.086666666666667
In Cell C1: Put the Forumula -
=VALUE(MID(A1,12,2))+VALUE(MID(A1,15,2))/60+VALUE(MID(A1,18,2))/3
600
That gives result of 42.9866666666667
So, B1 and C1 are the right numbers kind of, reversed order and
one should be negative.

So might require some additional work, but the math seems
simple.

On 21 Nov 2020 at 22:11, Gilles wrote:

Date sent:              Sat, 21 Nov 2020 22:11:59 -0700 (MST)
From:                   Gilles <codecomplete@free.fr>
To:                     users@global.libreoffice.org
Subject:                [libreoffice-users] [Calc] Convert GPS coords
from DMS to decimals?

```
```Hello,

I need to convert GPS coordinates from degrees+minutes+seconds (DMS) to
decimal, eg. 00°05'12"O 42°59'12"N -> 42.98666667,-0.08666667

https://postimg.cc/QH0q5qmn <https://postimg.cc/QH0q5qmn>

Can Calc do this, or should I look elsewhere?

Thank you.

--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
```
```

+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/