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

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"dougsan" wrote:

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dougsan" wrote in message
...
how do i work with Degrees and minutes in angles and enter onto excel

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

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"dougsan" wrote:

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

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dougsan" wrote in message
...
how do i work with Degrees and minutes in angles and enter onto excel

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
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1

Thanks Chris
I am now on the right track
dougsan

"Chris_Bode via OfficeKB.com" wrote:

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
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1

Thanks Chris,

Your post was awesome, I got my way.

Puruzweb




Chris_Bode wrote:
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
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com