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.9867,-0.0867 In Cell B1: Put the Formula -

[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.9867,-0.0867 https://postimg.cc/QH0q5qmn Can Calc do this, or should I look elsewhere? Thank you. -- Sent from: