SOLVED

Converting text field of various units of time to hours

Copper Contributor

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 VI_Migration (Silver Contributor)
Solution

@Rjonspa Perhaps like in the attached file.

Screenshot 2022-04-11 at 07.56.46.png

 

 

Thank you so much Riny!
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Rjonspa Perhaps like in the attached file.

Screenshot 2022-04-11 at 07.56.46.png

 

 

View solution in original post