更新时间:2022-01-11 04:40:45
将粘贴内容的列预先格式化为纯文本:
pre-format the column in which you paste stuff to Plain text:
如果这还不够,那么使用这个公式来修正你的时间:
if that's not enought then use this formula to fix your times:
=ARRAYFORMULA(IF(A:A<>"", TEXT("00:"&A:A, "mm:ss"), ))