title: Format Excel, column to get sum of hh:mm:ss when they are listed that way
body: <p>I need to get the total duration time in hours:minutes:seconds when the list of time is all in one column.  The seconds need to convert into minutes and seconds when they exceed 60 and the minutes into minutes and hours.  I am getting the original data from a CVS format so it must all go into one column.  I need to use a formula that will give me the sum for each person's individual times. </p>
  
  <p>For example: a column like 01:22:03 added to 00:58:57 must come out to 02:21:00.  I have tried putting the format into custom time h:mm:ss but it does not work.  I have far too many to add on a weekly basis to do it by hand and I know someone has an answer for this new Excel user.</p>