Thanks Geetha, that's a little complicated but I suppose generally we require converting from DMS to decimal values, and the other way is hardly needed. Vikas Kapoor, MSN Id: [email protected], Yahoo&Skype Id: dl_vikas, Mobile: (+91) 9891098137. ----- Original Message ----- From: "Geetha Shamanna" <[email protected]> To: <[email protected]> Sent: Saturday, April 30, 2011 11:46 PM Subject: Re: [AI] Calculation from DMS to Decimals
For the vice versa conversion, assuming your number is in A1, try the following: =INT(A1)&CHAR(186)&" "&INT((A1-INT(A1))*60)&CHAR(145)&" "&ROUND((((+A1-INT(A1))*60)-INT((+A1-INT(A1))*60)),2)*60&CHAR(145) This is not my formula, and I have not verified it. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Vikas Kapoor Sent: 30 April 2011 18:24 To: [email protected] Subject: Re: [AI] Calculation from DMS to Decimals Hi Geetha, that perfectly worked, and if I'm allowed, what would be the formula for the vis-a-versa? And also, do you know the manual calculation for both as well? Vikas Kapoor, MSN Id: [email protected], Yahoo&Skype Id: dl_vikas, Mobile: (+91) 9891098137. ----- Original Message ----- From: "Geetha Shamanna" <[email protected]> To: <[email protected]> Sent: Saturday, April 30, 2011 10:27 PM Subject: Re: [AI] Calculation from DMS to Decimals Try the following method in Excel: To convert DMS values to decimal degrees (e.g., 45:30:30 to 45.50833), multiply the DD:MM:SS value by 24, and format the cell as General. For example, =A1*24. Geetha -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Vikas Kapoor Sent: 30 April 2011 13:07 To: Access India Subject: [AI] Calculation from DMS to Decimals Dear Friends, Can anybody tell me the simplest method, or any third party software, or scripts which could convert Latitude-Longitude coordinates from DMS to decimal values? I know there are many sites which can perform the same task easily but I don't wish to be necessarily online in order to be able to accomplish this. Vikas Kapoor, MSN Id: [email protected], Yahoo&Skype Id: dl_vikas, Mobile: (+91) 9891098137. Vikas Kapoor, MSN Id: [email protected], Yahoo&Skype Id: dl_vikas, Mobile: (+91) 9891098137. To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
