Need help summing time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone please offer help with summing the following example in excel so
that my result is returned in hours, minutes and seconds? The cell format is
general. Any help would be appreciated! Currently my sum result ends up as
0:00:00.
04:47:03
15:09:23
18:02:34
17:40:07
12:17:26
18:16:52
09:27:22
09:13:32
14:15:40
17:18:38
 
Try changing the cell format to Custom h:mm:ss and simply use the Sum
function. The result should be 136:28:37.
 
Correct, however, as long as the cells containing the data are formatted
h:mm:ss the sum cell will autoformat itself [h]:mm:ss.

David Biddulph said:
If it's 136:28:37, doesn't it need [h]:mm:ss rather than h:mm:ss ?
--
David Biddulph

j.ruderman said:
Try changing the cell format to Custom h:mm:ss and simply use the Sum
function. The result should be 136:28:37.
Click to expand...
Click to expand...
 
It depends, if they were entered as hh:mm then
summed it won't change if you change the format of the cells
to be totaled. However if you start by formatting the first cell as h:mm:ss
then enter the time values it will change correctly.




--


Regards,


Peo Sjoblom

j.ruderman said:
Correct, however, as long as the cells containing the data are formatted
h:mm:ss the sum cell will autoformat itself [h]:mm:ss.

David Biddulph said:
If it's 136:28:37, doesn't it need [h]:mm:ss rather than h:mm:ss ?
--
David Biddulph

j.ruderman said:
Try changing the cell format to Custom h:mm:ss and simply use the Sum
function. The result should be 136:28:37.

:

Can anyone please offer help with summing the following example in
excel
so
that my result is returned in hours, minutes and seconds? The cell
format
is
general. Any help would be appreciated! Currently my sum result ends
up
as
0:00:00.
04:47:03
15:09:23
18:02:34
17:40:07
12:17:26
18:16:52
09:27:22
09:13:32
14:15:40
17:18:38
Click to expand...
Click to expand...
Click to expand...
 
Back
Top