发布网友 发布时间:2022-04-28 13:30
共2个回答
热心网友 时间:2023-10-10 12:58
=IF(ISERROR(FIND("时",A2,1)),SUBSTITUTE(SUBSTITUTE(A2,"时",":"),"分",":")&":0",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"时",":"),"分",":"),"秒",":"))热心网友 时间:2023-10-10 12:58
可以设置单元格格式,热心网友 时间:2023-10-10 12:58
=IF(ISERROR(FIND("时",A2,1)),SUBSTITUTE(SUBSTITUTE(A2,"时",":"),"分",":")&":0",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"时",":"),"分",":"),"秒",":"))热心网友 时间:2023-10-10 12:58
可以设置单元格格式,