Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 2610' -- 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? 1315' + 1255' = 2610' Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiplicative calcuation | Excel Discussion (Misc queries) | |||
If And Calcuation | Excel Worksheet Functions | |||
Imputting an angle degree. Degree, minute, second | Excel Discussion (Misc queries) | |||
Imputting an angle degree. Degree, minute, second | Excel Worksheet Functions | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) |