E
Elton Law
Hi,
Is Excel capable to perfrom degree calculation please?
13°15' + 12°55' = 26°10'
Thanks
Is Excel capable to perfrom degree calculation please?
13°15' + 12°55' = 26°10'
Thanks
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
Stefi
J
JLatham
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
here:
http://answers.yahoo.com/question/index?qid=20081008100033AAzgam1
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.
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
here:
http://answers.yahoo.com/question/index?qid=20081008100033AAzgam1
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.
M
muddan madhu
may be like this
where E21 = 13.15, E22 = 12.55
=INT(E21+E22)+ROUNDDOWN(MOD(E21+E22,1)/0.6,1)
where E21 = 13.15, E22 = 12.55
=INT(E21+E22)+ROUNDDOWN(MOD(E21+E22,1)/0.6,1)
R
Roger Govier
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
__________ Information from ESET Smart Security, version of virus signature database 4521 (20091019) __________
The message was checked by ESET Smart Security.
http://www.eset.com
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 said: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
J
joel
Prpbebly a simple UDF will do the job. the values are treated in exce
as string so you havve to split the strings into angles and minutes an
the perform the addition seperately. The other choice is to enter th
angles as radians or angles with the partial amount as a fraction (1
minutes = 15/60 = .25)
=AddDegrees(A1,A2)
Function AddDegrees(Angle1, Angle2) As String
Deg1 = Val(Angle1)
Minutes1 = Val(Mid(Angle1, InStr(Angle1, "°") + 1))
Deg2 = Val(Angle2)
Minutes2 = Val(Mid(Angle2, InStr(Angle2, "°") + 1))
TotalDegrees = Deg1 + Deg2 + Int((Minutes1 + Minutes2) / 60)
TotalMinutes = (Minutes1 + Minutes2) Mod 60
AddDegrees = TotalDegrees & "°" & TotalMinutes & Chr(39)
End Functio
as string so you havve to split the strings into angles and minutes an
the perform the addition seperately. The other choice is to enter th
angles as radians or angles with the partial amount as a fraction (1
minutes = 15/60 = .25)
=AddDegrees(A1,A2)
Function AddDegrees(Angle1, Angle2) As String
Deg1 = Val(Angle1)
Minutes1 = Val(Mid(Angle1, InStr(Angle1, "°") + 1))
Deg2 = Val(Angle2)
Minutes2 = Val(Mid(Angle2, InStr(Angle2, "°") + 1))
TotalDegrees = Deg1 + Deg2 + Int((Minutes1 + Minutes2) / 60)
TotalMinutes = (Minutes1 + Minutes2) Mod 60
AddDegrees = TotalDegrees & "°" & TotalMinutes & Chr(39)
End Functio
D
David Biddulph
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'
=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'