7 Replies Latest reply: Oct 5, 2017 8:49 AM by Chanty 4u RSS

    Calculating Duration of a row of times

    Ali Ahmad

      Hi,


      I have a list of duration times and am wondering how I can sum these up to Days, Hours, Minutes and Seconds. It's a phone log and I am trying to calculate the average and total time spent on the phone. Here is an example of some of the rows:

       

       

      00:00:02
      00:00:03
      00:00:03
      00:00:03
      00:00:04
      00:00:04
      00:00:04
      00:00:05
      00:00:05

      This is hh:mm:ss

       

      Added Excel sheet also with a column of it.

       

      Don't know why, but I keep getting a total of 11 hours and x amounts of hours / mins?