the angle format (º ‘ ‘’) and calculation?

macropod · #1 04-23-2012, 04:40 AM

Quote:

Originally Posted by Catalin.B

As Paul sugested, use (A1+A2)/24 in a custom formatted cell and you will have the same answer as the UDF. The problem with this approach is that you cannot enter a value in DMS, values can only be entered in decimal system.

Actually, you can - simply input the DMS in HH:MM:SS format into a cell formatted with my custom number format. For example, for an angle of 10º15'22'', input 10:15:22. To get the decimal equivalent of that in another cell, simply multiply it by 24.

BTW: Who uses centesimal angular measures?

Catalin.B · #2 04-23-2012, 04:45 AM

Quote:

Actually, you can - simply input the DMS in HH:MM:SS format into a cell formatted with my custom number format. For example, for an angle of 10º15'22'', input 10:15:22. To get the decimal equivalent of that in another cell, simply multiply it by 24.

And again i bite the dust... :d

Jamal NUMAN · #3 04-23-2012, 01:45 PM

Quote:

Originally Posted by macropod

Actually, you can - simply input the DMS in HH:MM:SS format into a cell formatted with my custom number format. For example, for an angle of 10º15'22'', input 10:15:22. To get the decimal equivalent of that in another cell, simply multiply it by 24.

BTW: Who uses centesimal angular measures?

Thank you guys for the help. This is very useful.

I’m wondering why the Excel doesn’t have such data format as built in feature.

We use complicated computations in the engineering surveying that includes angles as a main data. All the computations are based on the angles in DMS.

For example, as we collect angle data from the fields, the sum of the measured angles for any polygon should equal (n-2)*180. If the sum is different from this value, then the error is calculated and then distributed in all the measured angles. This is why a lot of angle computation is involved (screenshot).

I couldn’t find the ##º##’##.##’’ on the custom (the screenshot is attached) so that I can make the 10:15:22 appears as 10º15’22’’

How can i enter all the angle values (shown in screenshot one) so that they appear in DMS format and can be processed applying particular calculations.

Best

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculation	Lights	Excel	5	04-18-2012 04:31 AM
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Calculation within Cells	manich1	Excel	2	12-07-2011 02:59 PM
Angle Bracket Problem, STYLEREF in Header of a Protected Document	wordjunkie	Word	0	06-18-2010 04:34 AM