2020 Archives by date, by thread · List index

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

```Thanks everyone for the input.

Using regexes, I split the latitudes and longitudes so they're in their own
columns.

Brian Barker wrote
```
```I'm guessing that "O" means "east" (as in "ouest"?) and that the
alternatives to "O" and
"N" are "E" and "S" respectively?
```
```
Sorry, I didn't pay attention to that part.

O = ouest = West
E = est = East

Brian Barker wrote
```
```If 00°05'12"O 42°59'12"N is in A1, then
=(MID(A1,12,2)+(MID(A1,15,2)+MID(A1,18,2)/60)/60)*((RIGHT(A1,1)="N")*2-1)
will deliver 42.9866666667, and
=(LEFT(A1,2)+(MID(A1,4,2)+MID(A1,7,2)/60)/60)*((MID(A1,10,1)="E")*2-1)
will deliver -0.0866666667.
```
```
I tried this formula, but get error 509 ("operator expected"). Maybe it's
because the cell contains "Numbers"?

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

--
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/