Quote:
Originally Posted by Pecoflyer
|
I went back to the posts of Mr. Paul and found out that the answer of this question is documented there
1. The custom format [hh]˚mm'ss'' is used to display and facilitate the angles operations (attached)
2. The angle 45
˚15’20’’ is type as 45:15:20 in the cell that has that customized format
3. To convert degree/minute/second angle to decimal we just multiply by 24
4. To convert decimal angle to degree/minute/second we divide by 24
Best
Jamal