function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
raj jordanraj jordan 

How to calculate response time between changing status from one to other?

hi all, i have one custom field called "Response time". Whenever the status changes from new to progress the custom field should calculate that how much time it has taken between changing status from new to progress in days:hours:min:sec. Could you please help me through this.

Thanks in Advance,
Jordan
Akshay_DhimanAkshay_Dhiman
Hi Raj,

For that, you'd need to create 2 separate Date or DateTime fields, one to capture the Date/DateTime the field is set to Status A, and the other one to capture the Date/DateTime the field is set to Status B.

Then you would need to update the Date/DateTime fields using either a Workflow, Process, or Trigger when the Status field is changed. 

Then create a custom Formula(Number) field that uses a Formula like this 

DateField_B - DateField_A

Thanks 
Akshay
raj jordanraj jordan
Hi Akshay thanks for ur reply but my requirement is I have a object on which there is a status field with default value newl and whenever the status changes to progress the time between changing status new to progress should be displayed in one custom field that is response time. Can you help me through this. Thanks in advance