在我的通话软件中,我有02:35格式的时间(通话时间).我只强调它和ctrl + c.然后我去我的谷歌表,并通过ctrl + v将此文本粘贴到相应的列中.列格式为hh:mm:ss.但是粘贴后我得到的是02:35:00,而不是00:02:35
In my software for calling I have time in format 02:35 (duration of the call). I just highlight it and ctrl+c. Then I go to my google sheets and paste this text via ctrl+v into the corresponding column. The column formatting is hh:mm:ss. But after pasting I've got 02:35:00, instead of 00:02:35
我尝试了不同类型的列格式化,但没有任何效果.我无法使用公式进行这种格式设置,因为一大群人在自己的工作表中执行相同的过程,因此应该自动进行
I tried different types of formatting the column, but nothing has worked. I can't use formulas to make such formatting because a large team of people do the same procedures in their own sheets, so it should be automatically
推荐答案将要粘贴内容的列预格式化为纯文本:
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"), ))
更多推荐
Google表格的格式时间不正确
发布评论