Thread: Summing Time
View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

JDT

Format the cells to [hh]:mm through Formatcells...numbercustom

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"JDT" wrote in message
...
Hi,

I have a column with an amount of time entered. For ex:

1:38
2:05
3:00
0:45
6:27

etc.

When I try summing these time increments in another cell, the answer
is 0:00 if the total is over 24. I just need to be able to sum the
column and see how much total time there is--hours and minutes. I
know it's a simple solution.

Thanks.