Hi experts
I've got the following data output to work with.
---------------------
30 days 12 hours 18 minutes
1 day 1 hour 1 minute
45 minutes
6 hours 1 minute
---------------------
My goal is to convert this data into decimal hours.
As you can see, the data is irregular, sometimes there's only 1 number (i.e. NOT 06 hours).
Also the letters have different lenghth (day, days etc.)
I've tried to split the data up into cells for further processing but I'm getting the following problem
30
1
45
6
If there are no days, the hours jump into collum A and if there are no days and hours, the minutes jump in collum A.
I've tried to read out the cell with
=LEFT([@[*Time in Online Sessions]];2)*24
That works well, but how to handle the middle and the right part, if the length of numbers and text are varying?
Sorry for my bad english and thanks fpr your help.
Bookmarks