View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Old Keith Old Keith is offline
external usenet poster
 
Posts: 31
Default 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