Help

Formula to convert Geographic coordinates

Topic Labels: Formulas
718 0
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 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.

0 Replies 0