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

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

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

http://www.cpearson.com/excel/latlong.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"RAY" wrote in message
...
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