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.

While Microsoft Excel automatically reformats time values as hours and minutes, you can manually change the cell's time format to display the seconds as well.

If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an ...