问题描述
在 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 中转换时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！