Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Summing negative time | Excel Discussion (Misc queries) | |||
Summing Time Data | Excel Discussion (Misc queries) | |||
Summing Time | Excel Discussion (Misc queries) | |||
Summing Time | Excel Discussion (Misc queries) |