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:
Originally Posted by nobbyknownowt
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
|