Announcements
Hi!
I have an excel sheet where I have on the col k row 1 "30 minutes" and col k row 2 "2 hours and 30 minutes" and I need to add them and convert them to only minutes.
This program should work with more than 2 rows.
Thanks for the help!
I have created Sample flow
pleaae try this
and the code snippent is as given below
copy and paste in your PAD designer
SET Time1 TO $'''30 minutes'''SET Time2 TO $'''2 hours and 30 minutes'''Text.ParseText.RegexParseForFirstOccurrence Text: Time1 TextToFind: $'''.*(?=\\shours)''' StartingPosition: 0 IgnoreCase: False Match=> HoursText.ParseText.RegexParseForFirstOccurrence Text: Time1 TextToFind: $'''\\d{2}.*(?=minutes)''' StartingPosition: 0 IgnoreCase: False Match=> minutesText.ToNumber Text: minutes Number=> TextAsNumberText.ParseText.RegexParseForFirstOccurrence Text: Time2 TextToFind: $'''.*(?=\\shours)''' StartingPosition: 0 IgnoreCase: False Match=> Hours1Text.ParseText.RegexParseForFirstOccurrence Text: Time2 TextToFind: $'''\\d{2}.*(?=minutes)''' StartingPosition: 0 IgnoreCase: False Match=> Minutes1Text.ToNumber Text: Minutes1 Number=> TextAsNumber2SET AddHours TO (Hours + Hours1) * 60SET Addmin TO TextAsNumber + TextAsNumber2SET FinalOutput TO AddHours + Addmin
Hope this helps
Usha
Regex expressions for parse text is for minutes
\d{2}.*(?=minutes)
for hours
.*(?=\shours)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 233 Super User 2026 Season 2
David_MA 227 Super User 2026 Season 2
Mohsin Ali 178
