9 Replies Latest reply on Nov 27, 2017 7:07 PM by Shinichiro Murakami

    Calculation: Average of a time series in seconds and conversion in a DD:HH:MM:SS format

    Emmanuel Prado

      I have a time series in seconds representing a waiting time and I would like to:

       

      1] Calculate the average of this series (over a variable period of time).

      Q: How do a calculate the average of the series? I am able manage to set th variable time period.

       

      2] I want to display this average waiting time in a readable DD:HH:MM:SS format

       

       

      Any help would be very appreciated. Thank you.