Convert based on text

I want to convert the below column value into hours, can you please help?

2 weeks, 1 day, 6 hours, 30minutes

(1 week = 5 days) the above column should give me result in another column in hours. Please help me with formula.

By: Surendar

Leave a Reply

Your email address will not be published. Required fields are marked *