-
度分秒转数字:
//A1代表转换的单元格
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"°",":"),"′",":"),"″",)*24
-
数字转度分秒:
//C1代表转换的单元格
=TEXT(INT(C1),"0")&"°"&TEXT(INT((C1-INT(C1))*60),"00")&"′"&TEXT(((C1-INT(C1))*60-INT((C1-INT(C1))*60))*60,"00.0000")&"″"
度分秒转数字:
//A1代表转换的单元格
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"°",":"),"′",":"),"″",)*24
数字转度分秒:
//C1代表转换的单元格
=TEXT(INT(C1),"0")&"°"&TEXT(INT((C1-INT(C1))*60),"00")&"′"&TEXT(((C1-INT(C1))*60-INT((C1-INT(C1))*60))*60,"00.0000")&"″"