用了这个公式形态转化时间格式 结果是只显示部分数据 而且其中显示的一部分数据不对 不知道怎么回事
这里不是标准的。。用这个公式吧
FORMAT(TODATE(CONCATENATE("2023-07-08 ",REPLACE(REPLACE(REPLACE($$$,":",":")," ",""),".0",""))),"HH小时mm分钟ss秒")
FORMAT(TODATE(CONCATENATE("2023-07-08 ",REPLACE(REPLACE(REPLACE($$$,":",":"),"
FORMAT(REPLACE(REPLACE("0 0:18:48. 0"," ",""),".0",""),"HH小时mm分钟ss秒")