右建----设置单元格格式数字----------自定义--------------在类型框输入####"_"##"_"##" "##":"##":"##
=MID(A1,1,4)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)&":"&MID(A1,13,2)
=TEXT(A1,"#-00-00 00!:00!:00")
