Converting text field of various units of time to hours

New Contributor


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 Replies
best response confirmed by Sergei Baklan (MVP)

@Rjonspa Perhaps like in the attached file.

Screenshot 2022-04-11 at 07.56.46.png



Thank you so much Riny!