I have tabular data in degrees, minutes, seconds that I need to convert to decimal degrees in order to import the data into a GIS.
I has an Experts Exchange programmer help me with a function several months ago but I can't figure out how to apply the function to the attached spreadsheet. I'd also like to know whether or not it is possible to apply the function to a different data set with the same problem. I think I need to some how run the function but I don't know how to do it.
I have attached the sample data and the code here.
I would really appreciate any guidance.