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일 오후 1: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