Degrees Minutes and Seconds

Y

Yosof Ewing

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

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.
 
L

Landxlii

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

Guest

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

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...
 
Y

Yosof Ewing

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
 
Top