×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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

Angle values in Excel

Angle values in Excel

Angle values in Excel

(OP)
Hi everyone,
I have a "little" problem and I am not sure weather Excel can do this or not.
I am trying to enter angle in a cell in degrees minutes and seconds (all in one cell eg A1) and in the next column I am trying to have it converted back to degrees only (eg. B1.

Is anyone out there that can help me to solve this problem, or at least to let me know weather this is possible to do in Excel or not.

Thanks in advance

RE: Angle values in Excel

Hello,

Firstly, how are you entering the data, can you give an example and also its format.

----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

RE: Angle values in Excel

Hello,

I am about to go home,

if you enter the value as 32:13:48 all you need to do is format this cell as hh:mm:ss and then multiply by 24.

To do it the other way just divide by 24 and format as [h]:mm:ss.

May I suggest you visit http://www.cpearson.com/excel/latlong.htm


----------------------------------
Hope this helps.
----------------------------------

maybe only a drafter
but the best user at this company!

RE: Angle values in Excel

This was discussed before.  The only thread I could find was:
Thread770-23997

I'm not sure it's then one I'm thinking of, but maybe it can help.

Ken

RE: Angle values in Excel

(OP)
thanks a lot onlydrafter it works and I have also foun another way with a bit longer formula.

Anyway, problem solved

cheers mate

RE: Angle values in Excel

Here's a formula that I stumbled across and modified a little to fit my needs. Enter your angle in a cell as dd.mmssss. The seconds are ss.ss entered as ssss.

formula to convert to dms to dd:

=(MID(A7*1000000,1,LEN(A7*1000000)-6)+MID(A7*1000000,LEN(A7*1000000)-5,2)/60+MID(A7*1000000,LEN(A7*1000000)-3,4)/360000)



RE: Angle values in Excel

Sorry, I just realized that i am off by a factor somewhere, and this formula doesnt work for angles less than one degree. ill try get back to you with the correct formula.

again i apologize.

RE: Angle values in Excel

Ok, I'm back. I figured it out but it's a little messy. I had to split the formula with an IF statement to make it work for angles less than 1. Sorry about that.

Here it is:

=IF(A7>=1,(MID(A7*1000000,1,LEN(A7*1000000)-6)+MID((A7+1)*1000000,LEN((A7+1)*1000000)-5,2)/60+MID((A7+1)*1000000,LEN((A7+1)*1000000)-3,4)/360000),MID((A7+1)*1000000,LEN((A7+1)*1000000)-5,2)/60+MID((A7+1)*1000000,LEN((A7+1)*1000000)-3,4)/360000)

RE: Angle values in Excel

and it's still the same entry format:
dd.mmssss  where ssss=(ss.ss)

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



News


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