用分钟和秒在 Excel 中转换时间 [英] Converting Times in Excel with minutes and seconds

问题描述

在 Excel 中，我需要能够提取作为 [h]:mm:ss 输入的 51:25:00 的时间并将其转换为分钟和秒为 51:25 并让输出显示 51:25 如 51 分钟 和 25 秒. 一旦我提取了那个时间，我需要将它全部转换为分钟，以便转换为 51.467 分钟，这样我就可以用这些分钟执行其他计算.

In Excel, I need to be able to extract a time of 51:25:00 that is entered as [h]:mm:ss and convert it into minutes and seconds as 51:25 and have the output show 51:25 as in 51 minutes and 25 seconds. Once I have extracted that time I need to convert it all into minutes so into 51.467 minutes that way I can perform other calculations with those minutes.

由于原始单元格的格式，我无法找到使用 LEFT() 或 MID() 的方法.

I cannot figure out a way to use LEFT() or MID() because of the format of the orginal cells.

我可以以 51:25 的格式输入值，格式为:[mm]:ss 但这非常耗时.但我也不知道如何将时间提取为分钟.

I can enter in values as 51:25 with the format: [mm]:ss but that is quite time consuming. But I also do not know how to extract that time into minutes.

我正在寻找可以将 [h]:mm:ss 转换为所需的 [mm]:ss 的公式，然后是另一个公式来查看分钟.

I am looking for a formula that can convert the [h]:mm:ss into the required [mm]:ss and then another formula to look at the minutes.

推荐答案

可能类似于以下内容:

=MINUTE(A1/60)+SECOND(A1/60)/60

也许更强大，

=HOUR(A1/60)*60+MINUTE(A1/60)+SECOND(A1/60)/60

这篇关于用分钟和秒在 Excel 中转换时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！