How can I create list of degrees,minutes,seconds

O

Old Keith

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

Keith
 
D

driller

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

Old Keith

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

driller said:
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..



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

Keith
 
D

driller

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



Old Keith said:
thanks "driller"- it's perfect !!!
old keith

driller said:
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..



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

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top