## 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

[h].mm.ss: this interprets the number that's in the cell as a number of days and transforms it in total hours followed by minutes and seconds of time that are just like the minutes and seconds of an angle.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

showthose numbers in a number of ways by means of predifined or custom formats. You can even enter those numbers using the format, for example a time by writing 1.25.58 (that will be internally transformed to the number 0.05831), but you can't edit them using the same format, as, as far as I know, the format of the formula bar cannot be changed.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