Hi,
Is Excel capable to perfrom degree calculation please?

13°15' + 12°55' = 26°10'

Thanks

Maybe http://cpearson.com/excel/latlong.htm can help you.

Regards,
Stefi

€žElton Law€� ezt Ã*rta:

Hi,
Is Excel capable to perfrom degree calculation please?

13°15' + 12°55' = 26°10'

Thanks

I don't generally work with angles, so what I offer is probably rough and
could use improvement - someone else may come along and give you a better way.

One other has asked this question in the past, and an answer was provided
he
http://answers.yahoo.com/question/in...8100033AAzgam1

I came up with this for your example
=DEGREES(RADIANS(13 + 15/60)+RADIANS(12 + 55/60))
that will return 26.16667

Hope this gets you headed in the direction you want to go.

"Elton Law" wrote:

Hi,
Is Excel capable to perfrom degree calculation please?

13°15' + 12°55' = 26°10'

Thanks

may be like this

where E21 = 13.15, E22 = 12.55

=INT(E21+E22)+ROUNDDOWN(MOD(E21+E22,1)/0.6,1)


On Oct 19, 4:51*pm, Elton Law
wrote:
Hi,
Is Excel capable to perfrom degree calculation please?

13°15' + 12°55' = 26°10'

Thanks

Hi

No inbuilt function that I am aware of, but the following formula will work

With data in A1 and A2, try
=LEFT(A1,FIND("°",A1)-1)+LEFT(A2,FIND("°",A2)-1)+
INT((MID(A1,FIND("°",A1)+1,2)+MID(A2,FIND("°",A2 )+1,2))/60)
& "° " &
MOD(MID(A1,FIND("°",A1)+1,2)+MID(A2,FIND("°",A2) +1,2),60)&"'"

Formula has deliberately been broken into separate lines, but it should all
be on one line.

If you had a lot of values to add, then create 2 helper columns using the
left function to extract the degrees in column B and the mid function to
extract minutes into column C.
Sum each of column B and C
In the row below your summation (assumed row 11 in this case) add the
following formula to the B column
=B10+INT(C10/60)
and in column C
=MOD(C10,60)

Concatenate your result with
=B11&"° " &C11&"'"


--
Regards
Roger Govier

"Elton Law" wrote in message
...
Hi,
Is Excel capable to perfrom degree calculation please?

13°15' + 12°55' = 26°10'

Thanks

__________ Information from ESET Smart Security, version of virus
signature database 4521 (20091019) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4521 (20091019) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Why bother converting to radians and back again?
=13+15/60+12+55/60 gives the same as your =DEGREES(RADIANS(13 +
15/60)+RADIANS(12 + 55/60))

Otherwise if you have 13:15 in one cell and 12:55 in another, just add them
and format the result as [h]:mm to get 26:10 or as [h]"°"mm"'" to get
26°10'
--
David Biddulph

"JLatham" wrote in message
...
I don't generally work with angles, so what I offer is probably rough and
could use improvement - someone else may come along and give you a better
way.

One other has asked this question in the past, and an answer was provided
he
http://answers.yahoo.com/question/in...8100033AAzgam1

I came up with this for your example
=DEGREES(RADIANS(13 + 15/60)+RADIANS(12 + 55/60))
that will return 26.16667

Hope this gets you headed in the direction you want to go.

"Elton Law" wrote:

Hi,
Is Excel capable to perfrom degree calculation please?

13°15' + 12°55' = 26°10'

Thanks