Degrees Minutes and Seconds

[Yosof Ewing]

Can anyone tell me how to convert an angle in standard
degree format into degrees, minutes and seconds?

 

[Guest]

For a decimal degree value in A16, try:
=INT(A16)&CHAR(176)&(INT((A16-INT(A16))*60)&"'")&FIXED
((A16-INT(A16))*3600-(INT((A16-INT(A16))*3600/60))*60,2)
&""""

The FIXED function rounds the seconds to 2 decimal places
(the final "2" in the long expression). Adjust the "2" to
what ever number of decimals you want in the seconds
portion.

Hope this helps.

 

[Landxlii]

degrees = INT(angle)
minutes = INT( (angle - degrees)*60 )
seconds = INT( (angle - degrees - minutes/60)*60*60 )

 

[Guest]

Sorry... I tested with a positive value, but this formula
is not correct for negative values. I'll try again.

 

[Guest]

Corrected for both positive and negative angles...

=IF(A16<0,-INT(ABS(A16)),INT(A16))&CHAR(176)&(INT((ABS
(A16)-INT(ABS(A16)))*60)&"'")&FIXED((ABS(A16)-INT(ABS
(A16)))*3600-(INT((ABS(A16)-INT(ABS(A16)))*3600/60))*60,2)
&""""

I hope...

 

[Guest]

Thanks for that, can you also help with "inverse tan". What i am trying to do
is return the value of opposite over adjacent as a whole circle bearing but I
am a wee bit lost?

Yosof