i hope this can help........................
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 A2=ROUNDUP((A1+B1/60+C1/3600),6) Then I turn it back to dms by this formula: A3=TRUNC(A2) B3=TRUNC((A2-A3)*60) C3=((A2-A3)-(B3/60))*3600 --> set cell as number in 2 decimal 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
Convert Angle to DMS.xls
Description: MS-Excel spreadsheet
