Angle values in Excel 1

[tombak71]

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

 

[onlyadrafter]

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!

 

[onlyadrafter]

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!

 

[brengine]

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

 

[tombak71]

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

Anyway, problem solved

cheers mate

 

[bbuubb]

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)

 

[bbuubb]

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.

 

[bbuubb]

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)

 

[bbuubb]

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