calculate from degrees to degrees/minutes/seconds on excel?
I am a geomatics student and while using Microsoft Excel I find that there is
no method to automatically change from degrees to degrees/minutes/seconds. If there is an add-in could you please tell me where it is? thanks |
calculate from degrees to degrees/minutes/seconds on excel?
You could use this, if decimal degrees are in A1
=A1*.0416666666667 then format cell/custom [H]° mm"m" ss "s" The degree symbol is Alt-248 Keep in mind that Excel performs Trig functions on Radians, so conversion is necessary Beege "C. Hollinger" wrote in message ... I am a geomatics student and while using Microsoft Excel I find that there is no method to automatically change from degrees to degrees/minutes/seconds. If there is an add-in could you please tell me where it is? thanks |
All times are GMT +1. The time now is 11:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com