Dear all,

I just join this mailing list. Nice to know you all. I hope forum would help
my problem.
I have angle data which inputted in Degree Minute Second (dms) in each cell.
A1=46 (degree)
B1=2 (minute)
C1=0 (second)

Then I use this formula to get a value in Degree.
A2=A1+B1/60+C1/3600

Then I turn it back to dms by this formula:
A3=TRUNC(A2)
B3=TRUNC((A2-A3)*60)
C3=((A2-A3)-(B3/60))*3600

This formula is correct if A3 isn't zero (0), but it will be incorrect if A3
is zero (0). For the example:
------------------------------
Data | Values | Expected
~~~~~~~~|~~~~~~~~~~|~~~~~~~~~~
A1=46 | A3=46 | A3=46
B1=2 | B3=2 | B3=2
C1=25 | C3=25 | C3=25
--------|----------|----------
A1=46 | A3=46 | A3=46
B1=2 | B3=1 | B3=2
C1=0 | C3=60 | C3=0
--------|----------|----------
See.., C3 should be <60.
Any idea about this?

Btw Mr. Abimono, I bought your 50 Jurus Rahasia Excel. It's awesome. I knew
this mailing list from that book. I really expect your next book.
Regards,
Rae - Papua