Converting text field of various units of time to hours

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!