Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Degree minutes seconds

Degree minutes seconds

Degree minutes seconds

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?

Rick Kitson MBA P.Eng

Construction Project Management
From conception to completion

RE: Degree minutes seconds

A trick may be that you use the format for times as [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.

Online tools for structural design

RE: Degree minutes seconds

That will work with the built in format of elasped hh.mmss but what I was looking for was someway of entering and using numbers in degrees. minutes and seconds rather than radian.

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

RE: Degree minutes seconds

I can't see a straight through way of doing what you want. In Excel you cannot do directly numerical operations on anything that is not a number (dates are numbers, currency values are numbers), but you can show those 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...

Online tools for structural design

RE: Degree minutes seconds

if you enter the angle/bearing as 56:25:33 then Excel treats this as HH:MM:SS. if you multiply this by 24, and change the formatting to decimals, you will have decimal degrees. then simply use the =radians() function to convert to radians.

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

i have some code for a custom function that goes from HMS to decimal and vice versa...email me at dfiler@hntb.com and i can send it to ya

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close