Quote:
Originally Posted by Pecoflyer
|
Thank you Pecoflyer for the help,
The link you have provided is very useful. The issue here is the conversion is for viewing purposes only. For example, if the values are required to be summed then this operation can’t be performed directly.
The issue here is that Excel doesn’t understand the format of angles and thus can’t handle correctly their algebra.
Paul has provided workaround to this problem in which angles are presented in the required format and the operations are also working
Other relevant threads are
Angles calculations
https://www.msofficeforums.com/excel...lculation.html
Angle format (degree/minute/second)
https://www.msofficeforums.com/excel...mat-excel.html