Latitude Longitude Functions
Written by
Reviewed by
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
