First, I would ask that the data be generated in a more suitable format. Have all data in the time column exported as hh:mm:ss with no succeeding text.
But you can work with the data on hand until then by entering a conversion equation to the right (here for the data on line 2):
=LEFT(B2, FIND(" ",B2)-1)/IF(RIGHT(B2,5)="Hours",1,60)
See attached. I formatted the column C as h:mm:ss so the complete time is shown.
|