#1
|
|||
|
|||
How to obtain the inverse tan of a value in degree/minute second?
How to obtain the inverse tan of a value in degree/minute second?
In the attached screenshot, I wanted to find the inverse tan of -1.5. I applied the equation shown in the screenshot but the result is not given in degree/minute/ second? Is there a way to obtain the inverse tan of a value degree/minute/second? Thank you Best Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#3
|
|||
|
|||
Quote:
Thank you Pecoflyer for the help, The link you have provided is very useful. The issue here is the conversion is for viewing purposes only. For example, if the values are required to be summed then this operation can’t be performed directly. The issue here is that Excel doesn’t understand the format of angles and thus can’t handle correctly their algebra. Paul has provided workaround to this problem in which angles are presented in the required format and the operations are also working Other relevant threads are Angles calculations https://www.msofficeforums.com/excel...lculation.html Angle format (degree/minute/second) https://www.msofficeforums.com/excel...mat-excel.html
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
|||
|
|||
Quote:
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
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 |