用公式解算出来!如123.6789在第一行第一列,则公式为“=TRUNC(A1)&"°"&TRUNC((A1-TRUNC(A1))*60)&"′"&ROUND(((A1-TRUNC(A1))*60-TRUNC((A1-TRUNC(A1))*60))*60,4)&"″"”
=TEXT(A1/24,"[h]°mm′ss.00″")=TEXT(A1/24,"[h]°mm′ss″")