Skip to main content
Vimal Raj が「#Data Management」で質問
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 件の回答
  1. 2017年10月26日 13:44
    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