Create your own formula to convert the degrees, minutes and seconds used in geography to a decimal number. DMS map coordinates consist of whole number degrees that are divided into 60 minutes.

Insert Time Formula Select the cell you want to convert to a time format in your Excel workbook. Click on the "Formulas" tab to open the Formulas ribbon.