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

Attached Images

	Clip_432.jpg (74.2 KB, 26 views)
	Clip_433.jpg (99.1 KB, 24 views)

Try this link

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Attached Images

	Clip_441.jpg (58.5 KB, 25 views)
	Clip_442.jpg (76.0 KB, 24 views)
	Clip_443.jpg (76.8 KB, 24 views)

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

Attached Images

	Clip_456.jpg (86.9 KB, 26 views)
	Clip_457.jpg (75.4 KB, 23 views)
	Clip_458.jpg (75.5 KB, 24 views)

Attached Files

Angles.xlsx (10.4 KB, 23 views)