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

Do you think state sales tax should be charged in the United States on all Internet sales?

Discuss in The Lounge

Poll History