View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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