View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j.ruderman[_2_] j.ruderman[_2_] is offline
external usenet poster
 
Posts: 18
Default 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