# API or script to convert DMS to DD **URL:** \ **Category:** Ask for Help\ **Created:** [July 14, 2020, 7:07pm UTC](https://community.glideapps.com/t/api-or-script-to-convert-dms-to-dd/12487 "2020-07-14T19:07:30Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [July 14, 2020, 7:07pm UTC](https://community.glideapps.com/t/api-or-script-to-convert-dms-to-dd/12487/1 "2020-07-14T19:07:30Z")
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 | ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 14, 2020, 7:12pm UTC](https://community.glideapps.com/t/api-or-script-to-convert-dms-to-dd/12487/2 "2020-07-14T19:12:39Z")
There is a formula here. [https://www.latlong.net/degrees-minutes-seconds-to-decimal-degrees](https://www.latlong.net/degrees-minutes-seconds-to-decimal-degrees) ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [July 14, 2020, 7:59pm UTC](https://community.glideapps.com/t/api-or-script-to-convert-dms-to-dd/12487/3 "2020-07-14T19:59:41Z")
@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