Conversion formula

[datadummy]

I am seeking help on a conversion formula that would take for example "2 days 16hours" and convert it to total hours, is this possible?

 

[Rick Rothstein]

I am seeking help on a conversion formula that would take for example "2 days 16hours" and convert it to total hours, is this possible?

Will there always be a space before the word "hours" (your example does not show one... just wondering if that was a typo)?

Will there always be some number of days or could that part of the text be missing sometimes?

 

[datadummy]

The format is currently as follows, # days # hours.

Will there always be a space before the word "hours" (your example does not show one... just wondering if that was a typo)?

Will there always be some number of days or could that part of the text be missing sometimes?

 

[Rick Rothstein]

The format is currently as follows, # days # hours.

Give this formula a try...

=24*LEFT(A1,FIND(" ",A1))+MID(SUBSTITUTE(A1," ",REPT(" ",100)),200,100)

 

[datadummy]

That is seriously impressive, thanks!!!