Forum Discussion
Solved
Angles
Good day all
Does anyone know how to convert an angle (or time) into a decimal format and then visa versa
Are you sure that you copied and edited the formula correctly?
For cells in which you enter a value such as 30.30.3: either format the cells as text before entering data, or prefix the values with an apostrophe ' to force Excel to treat them as text.
I have attached a sample workbook with two VBA functions: DMS2Dec and Dec2DMS. You can view them by pressing Alt+F11.
(Remark: VBA only works in the desktop version of Excel for Windows or Mac OSX, not in Excel for Android or iOS, nor in the online/browser version of Excel)
The workbook is a macro-enabled workbook (.xlsm), so you'll have to allow macros when you open it.
9 Replies
- Not sure if I understand your question. Do you mean convert from degrees into radians?
- Hi Johnthefisherman
No .... I would like to decimalize an angle ie: 30 degrees 30 minutes 30 seconds = 30.50833336
and then do it backwards ie: 30.50833336 = 30.30.30- I found this page:
https://blog.batchgeo.com/convert-latitude-longitude-to-decimals-excel/#:~:text=%3DDegree%2BMinute%2F60%2BSecond%2F3600&text=Add%20a%20heading%20(such%20as,the%20rest%20of%20the%20column
It seems to answer your question hopefully
