This is a simple exercise to transform decimal angles to degrees, minutes and seconds.
A1=25.4 (decimal degrees)
B1=INT(A1)=25 (degrees)
C1=(A1-B1)*60= should be 24 (minutes)
C1=23.999999999999900000, this is supposed to be 24.000
A1-B1 gives 0.399999999999999.
I'm not using the ROUND() function.
Any reason for this rounding error? Am I doing something wrong here? Thanks.
Bookmarks