转换度分秒:
117.2814000 转换117°16′53.04″
=INT(D2)&"°"&INT((D2-INT(D2))*60)&"′"&ROUND((((D2-INT(D2))*60)-INT((D2-INT(D2))*60))*60,2)&"″"
=TEXT(A1/24,"[h]°mm′ss″")
117.2814000 转换117°28′14″
=INT(A1)&"°"&IF(INT((A1-INT(A1))*100)<10,"0"&INT((A1-INT(A1))*100),INT((A1-INT(A1))*100))&"′"&IF(INT((A1*100-INT(A1*100))*100)<10,"0"&INT((A1*100-INT(A1*100))*100),ROUND((A1*100-INT(A1*100))*100,2))&"″"
=INT(D16)&"°"&INT((D16-INT(D16))*100)&"′"&ROUND(((D16*100-INT(D16*100))*100),D82)&"″"
链接:https://pan.baidu.com/s/1Og_s-WH1inwNoEwoDUUwRA 密码:32hu