ADDATION OF DEGREE / MINUTES/SECOND

[HARSHAWARDHAN. S .SHASTRI]

WHAT I NEED IS ,A FORMULA WHICH CAN ADD SAY

90°30'42''
+30°54'40''
=-------------
121°25'22''

WAITING FOR URGENT REPLY.

HARSHAWARDHAN SHASTRI

INDIA

 

[Teethless mama]

In A1: 90:30:42
In A2: 30:54:40

In A3: =A1+A2

 

[HARSHAWARDHAN. S .SHASTRI]

In A1: 90:30:42
In A2: 30:54:40

In A3: =A1+A2

THANKS

FORMULA IS WORKING BUT IF SUM EXCEEDS 360° IT SHOULD SHOW AGAIN FROM
0°.AND SECOND DIFFICULTY IS I AM NOT GETTING SIN /COS/TAN VALUES CORRECTLY
IF I USE D:M:S FORMAT.

HARSHAWARDHAN SHASTRI