Solved 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


Example for Addition:-


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)


i need code for this calcultion.


See More: signs, degrees , minutes, seconds

Report •

April 17, 2018 at 10:59:52
✔ Best Answer
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.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question