Quote:
Originally Posted by Catalin.B
As Paul sugested, use (A1+A2)/24 in a custom formatted cell and you will have the same answer as the UDF. The problem with this approach is that you cannot enter a value in DMS, values can only be entered in decimal system.
|
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?