| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of items in a column? | Excel Worksheet Functions | |||
| Create List + Protection | Excel Discussion (Misc queries) | |||
| Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
| The pivot tables 101 article says to use the "Create List" comman. | New Users to Excel | |||
| create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Linear Mode
