How to obtain the inverse tan of a value in degree/minute second?

Jamal NUMAN · #4 07-27-2013, 10:18 AM

Quote:

Originally Posted by Pecoflyer

I went back to the posts of Mr. Paul and found out that the answer of this question is documented there

1. The custom format [hh]˚mm'ss'' is used to display and facilitate the angles operations (attached)
2. The angle 45˚15’20’’ is type as 45:15:20 in the cell that has that customized format
3. To convert degree/minute/second angle to decimal we just multiply by 24
4. To convert decimal angle to degree/minute/second we divide by 24

Best

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to write the degree, minute second format in excel	Jamal NUMAN	Excel	12	07-09-2018 11:44 PM
obtain file creation date using vba	mikec	Excel Programming	2	02-01-2013 02:30 AM
Run a macro each minute?	yabbah	Excel Programming	5	05-31-2012 01:01 AM
Upgraded from Outlook 2003 to 2010, after a minute, Outlook closes on its own	Ckingfly	Outlook	3	06-12-2011 07:43 AM
How to get the inverse of the values in the same table?	Jamal NUMAN	Excel	4	04-16-2011 06:24 AM