Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Formula to convert Degrees Minutes Seconds to Decimal Degrees

3300 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Thibaud_Donzier
6 - Interface Innovator
6 - Interface Innovator

Hi everyone,

I am looking for a Formula to convert Degrees Minutes Seconds (DMS) Geographic coordinates to Decimal Degrees (DD).

Right now I have one column lwith this format : 57°34’57.8"N 6°19’30.9"W
and I will need to split in two columns to have something like that :
57.582722
-6.325250

in order to use this mini estension : Embed Map of Airtable Records on Your Website(Embed Map of Airtable Records on Your Website - miniExtensions)
Embed Map of Airtable Records on Your Website - miniExtensions

If anyone has done this, thank you in advance !

4 Replies 4
Dominik_Bosnjak
10 - Mercury
10 - Mercury

Did the parsing part, I assume you can take it from here, just clone this base and the formulas should all be in there.

Hi @Dominik_Bosnjak

Thanks a lot for your help !
Unfortunatly I can’t clone this base, I can only use the data without the formulas.
And I am not sure to get what you did.

I am trying to convert this georgraphic coordinate Field : 57°34’57.8"N 6°19’30.9"W
in two columns :
Longitude Field : 57.582722
Latitude Airtable Field : -6.325250

Thanks for having a look :slightly_smiling_face:

Dominik_Bosnjak
10 - Mercury
10 - Mercury

I… am not at my best at 4am in the morning, apparently. I’ve just published the whole thing to the Universe, so you should be able to pull it now.

Hi thanks :slightly_smiling_face:
But I’m not sure if this answers my problem. It should be a convertion and not just split the georgraphic coordinate and the format should be -6.325250

Thanks anyway for your help!