It can be done with regular string functions. Not sure what to do with the last row... what do you want ?
Hours + Minutes/60 as HourInDecimals;
A as Time,
num(left(A, Index(A,'Hrs')-2)) as Hours,
num(mid(A, Index(A,'Hrs') + 5 , Index(A,'Min')- (Index(A,'Hrs')+5))) as Minutes
(ooxml, no labels, table is Sheet1);