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

At 05:20 22/11/2020 -0700, Gilles Noname wrote:
> 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"?

No, that's not what error 509 means.

> https://postimg.cc/w764P7Rm

You've shown us the error message, but with focus 
on a different cell, not showing the error. So 
no-one can see the erroneous formula! I'm 
guessing that your locale needs semicolons as 
separators in place of the commas.

I trust this helps.

Brian Barker


--
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/
Privacy Policy: https://www.documentfoundation.org/privacy