Home 
Search 
Today's Posts 
#1




convert angle minute to decimal
Hi There
I want to convert an angle 1 degree 02 minutes to decimal so that i can calculate the sine of the angle. now =1+(.02/60) gives me the answer but how do I automate it so that a 1.02 input in one cell will give me the desired 1.03 result. Can I use the part of the input behind the decimal point and divide it? Or do i need to split the input into 2 seperate cells? cheers Nobby 
#2




convert angle minute to decimal
http://www.cpearson.com/excel/latlong.htm has info on the right way to do
it. If you have already put the data in with the decimal point as the separator, rather than a colon, you could use something like =INT(A2)+(A2INT(A2))*100/60 or =INT(A3)+MOD(A3,1)*100/60 but you'll need to alter the formula if the angles could be negative. Note also that it's not =1+(.02/60) as you had, but =1+(.02*100/60).  David Biddulph "nobbyknownowt" wrote in message ... Hi There I want to convert an angle 1 degree 02 minutes to decimal so that i can calculate the sine of the angle. now =1+(.02/60) gives me the answer but how do I automate it so that a 1.02 input in one cell will give me the desired 1.03 result. Can I use the part of the input behind the decimal point and divide it? Or do i need to split the input into 2 seperate cells? cheers Nobby  nobbyknownowt 
#3




if u are happy with angles considering down to the minute level [without the seconds level]
try this on A1: type 1.02 : [this is 1 degree and 02 minutes only] : A1 must be down to 2 decimals max. only. =INT(A1)+(A1INT(A1))/60*100 happy holidays hohoho pura vida romelsb Quote:

Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Convert decimal degree (lattitude/longitude) into Degree,  Excel Discussion (Misc queries)  
Convert decimal hour into time format?  Excel Discussion (Misc queries)  
convert decimal number to time : convert 1,59 (minutes, dec) to m  Excel Discussion (Misc queries)  
how to convert total hours (HH:MM) into decimal number  Excel Worksheet Functions  
convert 100 minute hour to a 60 minute hour  Excel Worksheet Functions 