Decimal Degree to DegMinSec conversion?
I am a land surveyor. I find it necessary to convert
Decimal Degrees to Degrees, Minutes and Seconds and vice
versa, yet I cannot find this function in Excel books or
the Help menu. This is a standard key on an HP
calculator, I would think that EXCEL would handle it.
25 deg 30 min 15 sec= 25.50147 degrees
25.50147 degrees = 25 deg 30 min 15 sec
PS I can put each in a separate cell and divide min by 60
and seconds by 3600, but I can't convert the other way.