How can I create list of degrees,minutes,seconds

[Guest]

How can I create list of degrees,minutes,seconds, preferably with trig values
to 3 decimal places.

Keith

 

[David Biddulph]

Do you need seconds if you are looking for outputs to 3 decimal places?

 

[Guest]

Checkout:

http://www.cpearson.com/excel/latlong.htm

and

http://support.microsoft.com/Default.aspx?kbid=213449

 

[Guest]

maybe i am confused, you need list...try this way

on A2 is your trig degress in decimals <3 or more>

for degrees on B2 = trunc(A2,0)
for minutes on C2 = trunc((A2-B2)*60,0)
for seconds on D2= =(A2-B2-C2/60)*3600

e.g. a2=128.5515 degrees
B2=128 [degree]
C2=33 [minute]
D2=5.4 [second]

just maybe..

 

[Guest]

thanks "driller"- it's perfect !!!
old keith

maybe i am confused, you need list...try this way

on A2 is your trig degress in decimals <3 or more>

for degrees on B2 = trunc(A2,0)
for minutes on C2 = trunc((A2-B2)*60,0)
for seconds on D2= =(A2-B2-C2/60)*3600

e.g. a2=128.5515 degrees
B2=128 [degree]
C2=33 [minute]
D2=5.4 [second]

just maybe..
--
*****
birds of the same feather flock together..

How can I create list of degrees,minutes,seconds, preferably with trig values
to 3 decimal places.

Keith

 

[Guest]

you're welcome
--
*****
birds of the same feather flock together..

thanks "driller"- it's perfect !!!
old keith

maybe i am confused, you need list...try this way

on A2 is your trig degress in decimals <3 or more>

for degrees on B2 = trunc(A2,0)
for minutes on C2 = trunc((A2-B2)*60,0)
for seconds on D2= =(A2-B2-C2/60)*3600

e.g. a2=128.5515 degrees
B2=128 [degree]
C2=33 [minute]
D2=5.4 [second]

just maybe..
--
*****
birds of the same feather flock together..

How can I create list of degrees,minutes,seconds, preferably with trig values
to 3 decimal places.

Keith