Sum of Degree Angles

[Guest]

Does anyone know how to sum degrees, my degrees are in
cells. Example a1 105 52'08" a2 73 54'42"
Thank you!

 

[Sandy Mann]

I don't know if it is what you are looking for but as there are 60 seconds
in a minute and 60 minutes in an hour, if you custom format the cells as
"[h]:mm:ss" (without the quotes) then it will add up the degrees as if it
was time. The square brackets stop the hours from rolling over into days
when they reach 24.

HTH

Sandy

 

[Gord Dibben]

Check out Chip Pearson's pages on working with lat/long and degrees.

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

Gord Dibben Excel MVP

 

[Guest]

Thank you it works.

-----Original Message-----
I don't know if it is what you are looking for but as there are 60 seconds
in a minute and 60 minutes in an hour, if you custom format the cells as
"[h]:mm:ss" (without the quotes) then it will add up the degrees as if it
was time. The square brackets stop the hours from rolling over into days
when they reach 24.

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

Does anyone know how to sum degrees, my degrees are in
cells. Example a1 105 52'08" a2 73 54'42"
Thank you!

.