Removing characters from a String and replacing with something else

[EN6924]

Hello All,

I have a sample data, wanted to convert like below format -

Input	Output
00 Hours 35 Minutes 59 Seconds	35 Minutes 59 Seconds
00 Hours 06 Minutes 20 Seconds	6 Minutes 20 Seconds
00 Hours 45 Minutes 52 Seconds	45 Minutes 52 Seconds
01 Hours 16 Minutes 04 Seconds	1 Hour 16 Minutes 4 Seconds
00 Hours 27 Minutes 38 Seconds	27 Minutes 38 Seconds
02 Hours 23 Minutes 17 Seconds	2 Hours 23 Minutes 17 Seconds
00 Hours 58 Minutes 23 Seconds	58 Minutes 23 Seconds
00 Hours 10 Minutes 52 Seconds	10 Minutes 52 Seconds
00 Hours 07 Minutes 53 Seconds	7 Minutes 53 Seconds
03 Hours 36 Minutes 55 Seconds	3 Hours 36 Minutes 55 Seconds
03 Hours 10 Minutes 30 Seconds	3 Hours 10 Minutes 30 Seconds
01 Hours 40 Minutes 47 Seconds	1 Hour 40 Minutes 47 Seconds
15 Hours 25 Minutes 55 Seconds	15 Hours 25 Minutes 55 Seconds
03 Hours 08 Minutes 48 Seconds	3 Hours 8 Minutes 48 Seconds
00 Hours 00 Minutes 00 Seconds	Backup may be running or has been failed.
10 Hours 00 Minutes 00 Seconds	10 Hours
00 Hours 00 Minutes 07 Seconds	7 Seconds

I have already done it using Regex and Formula tool. 

Need help to create the output in more short way using Regex.

Thanks. 😊

[atcodedog05 · Accepted solution]

Hi @EN6924 

Here is how you can do it.

Workflow:

Hope this helps : )

[EN6924]

Great.. Thank you 😊

[atcodedog05]

Happy to help : ) @EN6924 

Cheers and have a nice day!