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 |
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)+(A2-INT(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 |
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)+(A1-INT(A1))/60*100 happy holidays hohoho pura vida romelsb:) Quote:
|
All times are GMT +1. The time now is 11:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com