Degree, Minutes, Seconds

A

AlanT

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
Access 2007,reports,VBA 2
How to determine the closest degree? 2
Convert decimal degree (lattitude/longitude) into Degree, 5
Decimal numbers in Excel 14
Countdown macro - display settings 2
convert an angle to degrees minutes seconds 1
Graduated dial face 2

Top