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