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