要输入两个公式,分别为:
第一个:
用来求B:E的值;数组,右拉,下拉;
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"天",","),"小时",","),"分",","),"秒",""),",",REPT(" ",99)),(COLUMN(A1)-1)*99+1,99))
第二个:
求总时间:
=SUM(--(B1:B3))&"天"&SUM(--(C1:C2))&"小时"&SUM(--(D1:D3))&"分"&SUM(--(E1:E3))&"秒"
也是数组
表结构如图: