Skip to main content

I'm trying to add a row-level formula, to calculate the difference between a case being created and the time that the first case comment is added, but I can not for the life of me get the field to present in a date/time format:

 

Average Response TimeCan anyone point me in the right direction?

 

Thanks 

 

Jess

 

 

#Formulas

9 answers
  1. Apr 29, 2024, 3:01 PM

    Okay give this a try

     

    Row-Level Formula

    Result = TEXT

    Formula = 

    FORMATDURATION(COMMENT_CREATED_DATE , CREATED_DATE )
0/9000