谷歌表格时间格式不正确 [英] Google Sheets format time incorrectly

问题描述

在我的通话软件中，我的时间格式为 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"), ))

这篇关于谷歌表格时间格式不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！