|
|
#3
07-26-2013, 04:34 AM
|
|||
|
|||
Quote:
Thank you Pecoflyer for the help, The link you have provided is very useful. The issue here is the conversion is for viewing purposes only. For example, if the values are required to be summed then this operation can’t be performed directly. The issue here is that Excel doesn’t understand the format of angles and thus can’t handle correctly their algebra. Paul has provided workaround to this problem in which angles are presented in the required format and the operations are also working Other relevant threads are Angles calculations https://www.msofficeforums.com/excel...lculation.html Angle format (degree/minute/second) https://www.msofficeforums.com/excel...mat-excel.html 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to write the degree, minute second format in excel
|
Jamal NUMAN | Excel | 12 | 07-09-2018 11:44 PM |
| obtain file creation date using vba | mikec | Excel Programming | 2 | 02-01-2013 02:30 AM |
|
Run a macro each minute?
|
yabbah | Excel Programming | 5 | 05-31-2012 01:01 AM |
|
Upgraded from Outlook 2003 to 2010, after a minute, Outlook closes on its own
|
Ckingfly | Outlook | 3 | 06-12-2011 07:43 AM |
|
How to get the inverse of the values in the same table?
|
Jamal NUMAN | Excel | 4 | 04-16-2011 06:24 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode