Formula to convert Geographic coordinates

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 with 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 :
Latitude : 57.582722
Longitude : -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 !

My first topic has been closed but it wasn’t resoled.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.