Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to convert Geographic coordinates

Topic Labels: Formulas
218 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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