I was trying to catch up on some reading this weekend, with all the traveling I’ve done this month my mail pile was beginning to tip over. One article that caught my eye was convert coordinates from decimal to DMS. We’ve all done this one way or another, but getting it done correctly in Excel was something I had never tried. Take a look at the link below to see how to create a formula that will convert decimal to DMS.
Degrees, Minutes, and Seconds in Excel - via PCMag