2 Replies Latest reply on Dec 3, 2018 6:04 AM by Robert Evans

    Average Duration

    Robert Evans

      I have a field Duration that is a text field. It reports in number of hours i.e.(Less than one hour, 7 hours etc.) I need to find the average duration between these values. I also have the Start and End Dates so the average time between dates per stage would work. Thanks.

        • 1. Re: Average Duration
          Ken Flerlage

          Your Average Duration calculated field is close. The only problem is that you're using the "day" in your datediff calculation. This will calculate the difference in units of days (not partial days). To make this a more precise value, I'd suggest using minutes, then dividing by the number of minutes in a day, like this:

           

          DATEDIFF('minute',[Start Date],[End Date])/1440

           

          This will give you the fraction of a day that is between the start and end date.

          • 2. Re: Average Duration
            Robert Evans

            Thanks, this worked. I also broke it down to hours.