Quote:
Originally Posted by fzuazua
If cell “E19” is 78.359272 in degrees decimal then:
CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""")
Will return:
78° 21' 33.38"
It may seem complicated but it give the exact format to put in to Google Earth or similar software. U can do all your calculations in decimal. If u use radians u must convert to degrees before applying the formula.
|
Hi fzuazua,
The code is working fine but sounds that it is for displaying purposes only. No calculations can be made!
So, for example, if the angles are required to be summed, then this operation can’t be performed
Is there still a way to have the correct display while the operations can also be preformed
Other relevant threads are
From decimal to degree
https://www.msofficeforums.com/excel...html#post50083
Angles calculations
https://www.msofficeforums.com/excel...lculation.html
Best
Jamal