
((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 件の回答

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