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

Ask Your Question

Weekly Poll

Would you be willing to go on a SpaceX trip around the moon?

Discuss in The Lounge

Poll History