嗨!你的359.5959不应该是359度59分59秒,转换为度分秒应该是359°35′45.24〃【TEXT(A1/24,"[H]°M′S.00〃")】但你要认为“回359度59分59秒”也行呀答。假设两组数值359.5959和123.4556,分别在A1和B1,要相加:就在C1输入LEFT(A1,FIND(".",A1)-1)+LEFT(B1,FIND(".",B1)-1)+INT((RIGHT(A1,4)-RIGHT(A1,2)+RIGHT(B1,4)-RIGHT(B1,2))/6000)&"."&MOD((RIGHT(A1,4)-RIGHT(A1,2)+RIGHT(B1,4)-RIGHT(B1,2)),6000)/100+INT((RIGHT(A1,2)+RIGHT(B1,2))/60)&MOD((RIGHT(A1,2)+RIGHT(B1,2)),60)回车。相减的就复杂一些了。