Imputting an angle degree. Degree, minute, second
 

Hey,
I am recording degrees in a land survey and wish to use excel to quickly
calculate the angles for me.
I am stuck as to how to imput an angle, not in decimal format, but in
degrees, minutes and seconds so I can then subtract one from the other.
From this I hope to work out how to calculate the mean of angles and the cos
and sine of the angles so you see I'm falling at the first hurdle.
Please help I have a hudge project starting and I hope this can save me time,

Graham
--
With a little help from my friends

Imputting an angle degree. Degree, minute, second
 

See

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


BUT please don't post in multiple newsgroups.

"Graham" wrote:

Hey,
I am recording degrees in a land survey and wish to use excel to quickly
calculate the angles for me.
I am stuck as to how to imput an angle, not in decimal format, but in
degrees, minutes and seconds so I can then subtract one from the other.
From this I hope to work out how to calculate the mean of angles and the cos
and sine of the angles so you see I'm falling at the first hurdle.
Please help I have a hudge project starting and I hope this can save me time,

Graham
--
With a little help from my friends