Quote:
Originally Posted by macropod
Actually, you can - simply input the DMS in HH:MM:SS format into a cell formatted with my custom number format. For example, for an angle of 10º15'22'', input 10:15:22. To get the decimal equivalent of that in another cell, simply multiply it by 24.
BTW: Who uses centesimal angular measures?
|
Thank you guys for the help. This is very useful.
I’m wondering why the Excel doesn’t have such data format as built in feature.
We use complicated computations in the engineering surveying that includes angles as a main data. All the computations are based on the angles in DMS.
For example, as we collect angle data from the fields, the sum of the measured angles for any polygon should equal (n-2)*180. If the sum is different from this value, then the error is calculated and then distributed in all the measured angles. This is why a lot of angle computation is involved (screenshot).
I couldn’t find the ##º##’##.##’’ on the custom (the screenshot is attached) so that I can make the 10:15:22 appears as 10º15’22’’
How can i enter all the angle values (shown in screenshot one) so that they appear in DMS format and can be processed applying particular calculations.