API or script to convert DMS to DD

Ask for Help
1

Anyone have experience in converting DMS to DD

Images uploaded from an iPhone to Cloudinary will include a number of metadata (exif). It seems as the caption position of the image is in DMS - but if I want it as latitude, longitude to be used in Glide I need to convert what is found in Cloudinary now.

Image Metadata Gpslatitude Image Metadata Gpslongitude
55 deg 42’ 29.86" N 12 deg 35’ 29.18" E
1 Like
2

There is a formula here.

https://www.latlong.net/degrees-minutes-seconds-to-decimal-degrees

3

@Jeff_Hager Thx. When the data is presented as 55 deg 42’ 29.86" N (and found in column CB2) then this formula works nicely

=mid(CB2,1,2)+mid(CB2,8,2)/60+mid(CB2,12,5)/3600

2 Likes