Degree minutes seconds
Degree minutes seconds
(OP)
Excel has trouble using degree minutes and seconds. As we know the trig functions use radian measure.
Anyone ever run across a macro that would convert between dd.mmss to radian and allow formating in dd.mmss?
Anyone ever run across a macro that would convert between dd.mmss to radian and allow formating in dd.mmss?
Rick Kitson MBA P.Eng
Construction Project Management
From conception to completion
www.kitsonengineering.com
RE: Degree minutes seconds
If this is not too complicated for you these would be the steps:
1)you have a cell with an angle in radians (that is perhaps the result of an inverse trigonometric function)
2)in another cell convert this to degrees (*180/pi)
3)in another cell convert the result 2 by dividing it by 24 (this can be done also in a single step under 2)
4)to the last cell apply the custom format as above.
prex
motori@xcalcsREMOVE.com
http://www.xcalcs.com
Online tools for structural design
RE: Degree minutes seconds
What i had been doing was using three columns, applying a custom format to have the proper symbols and then in a hidden colum converting them to decimal gegrees and then radians.
I would like to be able to add and subtract angles using dd.mm.ss formats and do other calculations with the angles.
Rick Kitson MBA P.Eng
Construction Project Management
From conception to completion
www.kitsonengineering.com
RE: Degree minutes seconds
Another way to attack the problem is that you enter your ddmmss as strings (just write in a cell something like 56°25'33' and Excel will consider it as a string), then write a VB function (e.g. dms2rad(dms as string)) that interprets it and returns the corresponding number in radians (this is not very difficult to write down). At that point you will enter in a separate cell the formula =dms2rad(ref) and do all subsequent calculations on that result.
This is not really very different from what you already do, but it's the best I can think of...
prex
motori@xcalcsREMOVE.com
http://www.xcalcs.com
Online tools for structural design
RE: Degree minutes seconds
RE: Degree minutes seconds
Check out the "How to work with angles (degrees, minutes, and seconds)" post on 8/05/02 for a lengthy discussion of this topic.
RE: Degree minutes seconds
RE: Degree minutes seconds