在Excel中将[h]：mm：ss转换为mm：ss-Convert[h]:mm:sstomm:ssinExcel

1  

Edit: It seems that the real issue is that the number before the colon is supposed to be minutes, but it has been stored as hours. So this is not just a display issue. You need to divide by 60 to turn hours to minutes and minutes to seconds.

编辑：似乎真正的问题是冒号之前的数字应该是分钟，但它已经存储为小时。所以这不仅仅是一个显示问题。您需要除以60才能将小时数分为几分钟和几分钟到几秒。

The text function allows you to display numbers in a different format. You can also apply this format: [mm]:ss in the cell itself using cell formatting without using a formula.

文本功能允许您以不同的格式显示数字。您也可以应用以下格式：[mm]：使用单元格格式化单元格中的ss而不使用公式。

If you want the total minutes:

如果你想要总分钟数：

=TEXT(A1/60,"[mm]:ss")

If you only want the minutes excluding hte hours:

如果你只想要除了小时的分钟数：

=TEXT(A1/60,"mm:ss")

0  

An hour has 60 minutes. Thus, if you multiply the hour times 60, you would get the number of the minutes. Then you should add the seconds:

一小时有60分钟。因此，如果您将小时乘以60，您将获得分钟数。然后你应该添加秒：

=HOUR(A2)*60 & ":" & SECOND(A2)

From the comment: The table displays the data correctly already. For record A2, the minutes in 32 and the seconds is 15.

从评论：该表已经正确显示数据。对于记录A2，分钟数为32，秒数为15。

If you think that your data is correct, then I have some bad news for you. Long story short - On C1, D1 and E1 write the following:

如果你认为你的数据是正确的，那么我有一些坏消息。长话短说 - 在C1，D1和E1上写下以下内容：

=Hour(A2)
=Minute(A2)
=Second(A2)

Then it will show:

然后它会显示：

8
15
0