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


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