Simply converts decimal ordinate to minutes from degrees-minutes-seconds format. Works for both longitude and latitude.
.
= DECIMALTOMINUTES (ordinate)
ordinate |
Decimal value, either a latitude or longitude. |
Decimal
Returns minutes value.
Example |
Returns |
= DECIMALTOMINUTES(37.39) |
Returns minutes value. |