• Sumit Rana 1
  • 0 Points
  • Member since 2018

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1

I am trying to set up an equation that will output the TOTAL amount of time that a case has been in 'On Hold' status.  I was able to figure out how to get the case to show the first 'on hold' status length, but after the status has been switched to, say, 'Working' and then back to 'On Hold' I need to be able to add on the new on hold status to the old.  The goal is to have a more accurate case time.

In a nutshell (total case open to complete time - on hold time = total working time)

I already have the below formula that outputs total case hold to complete time as a decimal:

Case_Open_Length__c =
BLANKVALUE(Complete_Date_Time__c, NOW()) - CreatedDate

I need a way to calculate the total hold time however, so that I can make an equation to factor it out.

Thank you in advance for any help!