signs, degrees , minutes, seconds

April 17, 2018 at 04:31:31
Specs: Windows 10
please tell me how to do this calculation in excel.

calculation should done by right side to left side


(signs-degrees-minutes-seconds)
(12-30-60-60)

Example for Addition:-

09-20-13-40
00-13-10-35
------------
10-03-24-15
------------

Example for Subtraction:-(in the below case we cannot delete 8 from 7. because we get 1 minute from minutes (i.e. 60 seconds) and from 67 seconds subtract 08 seconds)

03-10-05-07
00-00-04-08
-----------
03-10-00-59
-----------

i need code for this calcultion.

Thanks
Sankar.


See More: signs, degrees , minutes, seconds

Reply ↓  Report •

#1
April 17, 2018 at 10:59:52
Take a look at this thread to see if the answer can be found there.

Specifically, refer to the links that show some User Defined Functions (UDF) for converting degrees/minutes/seconds angles to or from decimal angles in Excel.

In that thread, I show the concept of using the UDF's to convert the degrees/minutes/seconds values into the decimal equivalents, do the math, and then convert the result back to degrees/minutes/seconds.

I hope that helps.

https://www.computing.net/answers/o...


message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question