如图,在天、小时、分钟单元格依次输入公式
=IF(ISERR(FIND("天",A72)),0,LEFT(A72,FIND("天",A72)-1))
=IF(ISERR(FIND("小时",A72)),0,MID(A72,IF(ISERROR(FIND("天",A72)),0,FIND("天",A72))+1,FIND("小时",A72)-IF(ISERROR(FIND("天",A72)),0,FIND("天",A72))-1))
=IF(ISERR(FIND("分钟",A72)),0,MID(A72,IF(ISERROR(FIND("小时",A72)),0,FIND("小时",A72))+2,FIND("分钟",A72)-IF(ISERROR(FIND("小时",A72)),0,FIND("小时",A72))-2))