×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

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

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

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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!