花了我半个小时,终于弄出来了,方法很笨,但有效
H3=IF(ISERROR(FIND("天",F3)),0,SUBSTITUTE(MID(F3,1,FIND("天",F3)),"天","")*24)+IF(ISERROR(FIND("小时",F3)),0,IF(ISERROR(FIND("天",F3)),SUBSTITUTE(MID(F3,1,FIND("小时",F3)-1),"小时",""),SUBSTITUTE(MID(F3,FIND("天",F3)+1,FIND("小时",F3)-(FIND("天",F3)+1)),"小时","")))*1+ROUND(SUBSTITUTE(SUBSTITUTE(RIGHT(F3,3),"分",""),"时","")/60,0)
下拉即可。
强烈要求加分!