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

    Variable expression for average time

      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'



      Any suggestions.