Latitude Longitude Functions

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2018

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

AI Formula Generator

Try for Free

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