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.

Select the cell you want to convert to a time format in your Excel workbook. ... "15" into the Minute field and then "30" into the Second field to set the time to 11:15:30 AM.