Excel-添加时间列以提供持续时间 [英] Excel - Adding time columns to give a duration

问题描述

我需要在excel中添加一列时间"，以得出总计的时间.我试图求和该列，但如果结果是>超过24小时我没有得到正确的答案，显然是因为时间实际上存储为DateTime值.

I have an need to add a column of Times in excel resulting in the accumlated time as a total. I tried to SUM the column but if the result is > than 24 hours I do not get the right answer, obviously because the time is actually stored as a DateTime value.

Any one offer a solution, I would be most grateful.

推荐答案

实际上，将单元格的格式设置为自定义"-> "[h]:mm:ss; @"会更简单.

看到这里:
http://support.microsoft.com/kb/214094 [

Actually, setting the format of the cell to "Custom" -> "[h]:mm:ss;@" will work out much simpler.

See here:
http://support.microsoft.com/kb/214094[^]

确定-我已经解决了:

公式如下:

= ROUNDDOWN(SUM(A1，A2)* 24，0)&MID(TEXT(SUM(A1，A2)，"hh:mm:ss")，3,6)

导致文本单元格如下所示:

29:51:23

即29小时51分23秒

OK - I''ve solved it:

formula is as follows:

=ROUNDDOWN(SUM(A1,A2)*24, 0) & MID(TEXT(SUM(A1,A2), "hh:mm:ss"),3,6)

Resulting in a text cell something like this:

29:51:23

ie 29 hrs, 51 mins, 23 secs

这篇关于Excel-添加时间列以提供持续时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！