香港腕表价格交流群

cad点坐标导出到excel表格再转成经纬度格式(附下载)

2023-05-25 17:04:50

CAD吧
每天四条CAD经典解决学习方案!


转换度分秒:


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



友情链接

Copyright © 2023 All Rights Reserved 版权所有 香港腕表价格交流群