API or script to convert DMS to DD

Ask for Help
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