Converting text field of various units of time to hours

[Rjonspa]

Hello,

I have a text column in excel that includes time but in various units. For example, one cell can be hours (i.e. 24 hours); another can be weeks (i.e. 3 weeks); or days (i.e. 2 days), etc.  Is there a formula I can use to covert all to hours and just display the number?
Thank you!

[#2 · Accepted solution]

@Rjonspa Perhaps like in the attached file.

[#3]

Thank you so much Riny!