Degree, Minutes, Seconds

G

Guest

Does excel accept numbers in degree, minutes, seconds format for angles or
does it only accept degrees and radians? If it does, what is the correct way
to do it and is there a conversion I can use to convert it to just regular
degree format? Thanks.
 
C

Chip Pearson

All of Excel's trig functions work only with radians, not
degrees. If you have degrees, convert them to radians with the
RADIANS function. When working with degrees, minutes, and
seconds, treat them as times.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to add degree,minutes and seconds 1
Convert decimal degree (lattitude/longitude) into Degree, 5
How to determine the closest degree? 2
convert an angle to degrees minutes seconds 1
Convert degree from decimal number to the standard format (degre. 3
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show 4
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal 2
Decimal numbers in Excel 14

Top