This short video shows you how to convert Latitude Longitude values from Degree, Minutes, Seconds into Decimal Degrees. There is two parts to this. The first being separating the DMS to separate columns for each value using text to column function, then the second using the math functions to convert the minutes and second to degrees to add to get decimal degrees.

свернуть