SOLVED

New Contributor

# 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!

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

# Re: Converting text field of various units of time to hours

@Rjonspa Perhaps like in the attached file.

# Re: Converting text field of various units of time to hours

Thank you so much Riny!