Sum of Degree Angles

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

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

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

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

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

Gord Dibben Excel MVP

On Sun, 5 Sep 2004 13:41:13 -0700,
wrote:

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

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

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



.