G2:01L2:2022-12-16 21:50:53F2:2022-12-16 23:48:01公式:if(len(G2)!=0,format(datesubdate(now(), L2, "h"), "00") + ":" + format(datesubdate(now(), L2, "m") % 60, "00") + ":" + format(datesubdate(now(), L2, "s") % 60, "00"),format(datesubdate(now(), F2, "h"), "00") + ":" + format(datesubdate(now(), F2, "m") % 60, "00") + ":" + format(datesubdate(now(), F2, "s") % 60, "00"))单元格显示的结果:13:55:16,且几条异常数据的结果均为13:55:16