How can I create list of degrees,minutes,seconds
 

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

Keith

How can I create list of degrees,minutes,seconds
 

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

"Old Keith" <Old wrote in message
...
How can I create list of degrees,minutes,seconds, preferably with trig
values
to 3 decimal places.

Keith

How can I create list of degrees,minutes,seconds
 

Checkout:

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

and

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


--
Gary's Student
gsnu200701


"Old Keith" wrote:

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

Keith

How can I create list of degrees,minutes,seconds
 

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" wrote:

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

Keith

How can I create list of degrees,minutes,seconds
 

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

"driller" wrote:

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" wrote:

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

Keith

How can I create list of degrees,minutes,seconds
 

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



"Old Keith" wrote:


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

"driller" wrote:

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" wrote:

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

Keith