Randomize coordinates within a given radius

[Thibaud_Donzier]

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.

Formula to convert Degrees Minutes Seconds to Decimal Degrees Formulas

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 - miniE…