问题描述
数据是:
A1 = 29. B1 = 30. C1 = 2.
D1 = TIME(A1, B1, C1).
如何让D1返回29:30:02?
将D1单元格格式化为[hh]:mm:ss无效！
如果我一个月内跑了29个小时，Excel会认为我只跑了5个小时.
谢谢.
谢谢！！我得到了它！！！ D1 = TIME(A1, B1, C1) + INT(A1 / 24)
您得到的结果正是时间函数起作用:
你可以做
D1 中的 =A1/24+B1/24/60+C1/24/60/60
然后格式为[hh]:mm:ss的结果值将显示29:30:02.
这是因为在Excel中1是1天.所以1/24是1小时，1/24/60是1分钟，1/24/60/60是1秒.
Data is:
A1 = 29. B1 = 30. C1 = 2.
D1 = TIME(A1, B1, C1).
How can I get D1 to return 29:30:02?
Formatting the D1 cell to [hh]:mm:ss does NOT work!
If I ran for 29 hours in a month, Excel thinks I ran for only 5 hours.
Thank you.
Edit: Thank you!! I got it!!! D1 = TIME(A1, B1, C1) + INT(A1 / 24)
The result you get is exactly how TIME function works:
You could do
=A1/24+B1/24/60+C1/24/60/60 in D1
Then the resulting value formatted as [hh]:mm:ss will show 29:30:02.
That is because 1 is 1 day in Excel. So 1/24 is 1 hour, 1/24/60 is 1 minute and 1/24/60/60 is 1 second.
这篇关于Excel TIME持续时间超过24小时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！