how do i enter angles in exel?

[dougsan]

how do i work with Degrees and minutes in angles and enter onto excel

 

[Shane Devenshire]

Hi,

Excel has a DEGREES function and a REDIANS function and PI(). take a look
at the help system for these functions.

You didn't tell us what you want to do with them.

 

[Bernard Liengme]

Chip has some stuff about degrees and minutes at
http://www.cpearson.com/excel/LatLong.aspx

To reinforce what Shane told you:
A1 holds value 60 (degrees) and you want SIN of that angle; use
=SIN(RADIANS(A1))
which first converts degrees to radians then finds the Sine

B1 holds number like .5678 and you want the Arcsine in Degrees; use
=DEGREES(ASIN(B1))

best wishes

 

[dougsan]

Thank you Shane Devenshire.
I am trying to set up a sheet to calculate navigation direction headings,
i.e. calculate compass headings from true headings, magnetic variation, and
deviation, ect

 

[dougsan]

Thank you, Bernard Liengme,
i will see how i go
dougsan

 

[Chris_Bode via OfficeKB.com]

There are several ways to measure the size of an angle. One way is to use
units of degrees. (Radian measure is another way.)

In a complete circle there are three hundred and sixty degrees.

In a full circle there are 360 degrees.
Each degree is split up into 60 parts, each part being 1/60 of a degree.
These parts are called minutes.
Each minute is split up into 60 parts, each part being 1/60 of a minute.
These parts are called seconds.

thus,
1 degree is equal to 60 minutes
1 minute is equal to 60 seconds
eg
use this formula for converting degree to minutes
40 degree 20 min 50 sec = 40 + (20/60) + (50/3600) degrees

1 minute = 1/60 degree



Chris

 

[dougsan]

Thanks Chris
I am now on the right track
dougsan

 

[Puruzweb]

Thanks Chris,

Your post was awesome, I got my way.

Puruzweb