6 Replies Latest reply: Jun 25, 2015 1:07 AM by Hasvine Dhurmea RSS

    Variable expression for average time

    Hasvine Dhurmea

      Hello Guys,

       

      I am trying to create a variable with the below expression:

       

      =interval(Avg({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}conv)/24, 'hh:mm:ss')

       

      The conv is the conversation time but unfortunately there is something wrong with the formula.

       

       

      When i do the expression as below i get the answer in numeric but I need it in time 'hh:mm:ss'

      =Avg({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}conv)

       

      Any suggestions.

       

      Thanks,

       

      Hasvine