Need help summing time
 

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

Perhaps this will help, Scott:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"ascottbag-hcm" wrote in message
...
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

Chip Pearson has lots of information on doing arithmetic with dates and
times:

http://www.cpearson.com/excel/datearith.htm

ascottbag-hcm wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Need help summing time
 

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

"ascottbag-hcm" wrote:

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

Need help summing time
 

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

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

"ascottbag-hcm" wrote:

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

Need help summing time
 

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" wrote:

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

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

"ascottbag-hcm" wrote:

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

Need help summing time
 

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" wrote in message
...
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" wrote:

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

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

"ascottbag-hcm" wrote:

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