G
Guest
Does anyone know how to sum degrees, my degrees are in
cells. Example a1 105 52'08" a2 73 54'42"
Thank you!
cells. Example a1 105 52'08" a2 73 54'42"
Thank you!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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
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
G
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
http://www.cpearson.com/excel/latlong.htm
Gord Dibben Excel MVP
G
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!
.