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
geis6geis6 

Help needed with reponse time formula

Hi...

I have a "Response Time" formula field that goes like this:
Response Time = (Actual_First_Response__c-CreatedDate) * 24

I want to be able to remove weekend days from the calculation to reflect our normal business hours.
While looking at some examples on your site I found this one below but I don't think this is exactly what I need:

CASE(MOD(My_Date__c - DATE(1900, 1, 7), 7), 0, 1, 6, 1, 0) = 0

I would like to do something like this but it doesn't scale for incidents create two or three weeks ago along with those created on the weekend:

IF(CreatedDate = This Week) THEN (Actual_First_Response__c - (CreatedDate - Sunday This Week))

IF(CreatedDate = Last Week) THEN ((Actual_First_Response__c - Sunday This Week) + (Saturday Last Week -  CreatedDate))

ELSE (Actual_First_Response__c - CreatedDate) I guess...

Any recommendations on best way to proceed in order to do this?

Cheers,
Ward