How do I use degrees, minutes and seconds in excel.

G

Guest

I am trying to add and subtract degrees, minutesand seconds using excel anfd
I have been unable to find the properway to enter the number. For example,
45deg 30min 20sec, how would I enter this in a cell so that I can set up a
worksheet to add or subtract cells with angular information?

Thank you
 

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

Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Excel degrees minutes 1
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
how to get readings in the form of degrees 1
Converting Degrees/Minutes/Seconds to Decimal Degrees 6
Want to display degrees, minutes, seconds. (0°00'00") 1
How do you convert decimal degrees to degrees minutes seconds 2
Converting the sine of an angle to degrees, minutes, and seconds 6

Top