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