Return to Excel Formulas List

Latitude Longitude Functions

Determine Degrees, Minutes, and Seconds

If you have coordinate values in time format, use the following functions to extract the degrees, minutes, and seconds.

=INT(a2) ‘Degrees
=MINUTE(a2) ‘Minutes
=SECOND(a2) ‘Seconds

If you have decimal degree values:

=INT(a2) ‘ Degrees
=MINUTE((A1-INT(A1))/24) ‘ Minutes
=SECOND((A1-INT(A1))/24) ‘ Seconds

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List