function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sujit KarandeSujit Karande 

Turn Around Time for for case record approval

Hi everyone, 

I receive a requirement from clients where they wanted to track the Turn around time for approval processes.

We have approval processes for Case object and we want to calculate something like this : 

Turn Around Time = Time when a case is approved - Time when a case is submitted for approval

Any suggestion? 
Manohar kumarManohar kumar

Hi Sujit, 
you can do something like this craete two field, and update them on approval submit and approved. And then a make formula field to get the interval. 

Thanks,
Manohar

Sujit KarandeSujit Karande
Hi Manohar,

Appreciate your help on this.

I was able to create two fields "ApprovedAt" and "SubmittedAt". Both of type Date/Time.

And it is recording the time successfully when a case is submitted and approved. But I would like to know which type of field should I create to calculate and store the result of (ApprovedAt - SubmittedAt)

Thank you,
Sujit
Manohar kumarManohar kumar

Hi Sujit, i am sorry for the late reply. I think you can use formula field to do this. 

have a look on this https://success.salesforce.com/answers?id=90630000000gkp8AAA 

Let me know if you need any help. 

Thanks,
Manohar