Can someone explain why I'm getting rounding errors in the attached spread sheet? DDtoDMS.xlsx
I'm expecting column 'T' to look like this
If E3 =0.55 and F3 = "E3*60"/33 so how can G3 = "INT(F3)" / 32?
My maths might be dodgy but 0.55 *60 = 33
Also how do I fix the leading zeros in the output?