計算成分钟 (9976)

D2=-LOOKUP(9,-LEFT(SUBSTITUTE(B2,":","小"),ROW($1:$9)))*60+RIGHT(SUBSTITUTE(B2,"分钟",":00"),5)*24

另解=(SUBSTITUTE(TEXT(SUBSTITUTE(TEXT(B2,"[h] m"),"分钟",),"\0 0"),"小时"," 0")&"/60")*60