Skip to main content
I'm using following formula to round up call duration value,for that we tried to extract the value '3' from "3 minutes 30 seconds" or '1' from "1 minute 20 seconds ".

 

 

((VALUE(TRIM(MID([CaseComment].CommentBody, FIND('tion - ', [CaseComment].CommentBody) + 7, 2))) *60) + VALUE(TRIM(MID([CaseComment].CommentBody, FIND('utes ', [CaseComment].CommentBody) + 5, 2)))) / 60

But above formula only gets "minutes",it's not applied for "minute".Also if i get "30 seconds" which doesn't contain a word "minutes/minute" returns empty result.

 

So now i need a formula to extract a value from (3 minutes 30 seconds) & (1 minute 20 seconds) & (20 seconds) using process builder

 

 
2 answers
  1. Oct 26, 2017, 1:44 PM
    Hi Sunil,

     

    It should return "3".

     

    Case :1

     

       Input : Duration 3 minutes 30 seconds

     

       Output : 3

     

    Case :2

     

      Input : Duration 3 minute 30 seconds

     

      Output : 3

     

    Case :3

     

      Input : Duration 30 seconds

     

      Output : 0

     

    Kindly reply me to get answer for these case using single formula