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.

Attached Files

msof query.xlsx (9.0 KB, 10 views)