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.
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
Ad Choices