输入=LEFT(A1,FIND("天",A1)-1)*24+MID(A1,FIND("天",A1)+1,FIND("小时",A1)-FIND("天",A1)-1)+ROUND(MID(A1,FIND("小时",A1)+2,FIND("分钟",A1)-FIND("小时",A1)-2)/60,2)&"小时"
