Convert text time to duration

[mousumimandal]

I have some text data as below. I want to convert it into duration ( in sec). How can I do that?

1 day 2 hours 3 minutes 4 seconds

2 days 1 hour 3 minutes

1 hour 2 minutes

3 hours 30 seconds

[mousumimandal]

Thank you

[Ahmedx · Accepted solution]

pls try this