EXCEL时间累加怎么计算总的需要多长时间答:=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(-...
WPS表格怎么计算时间加减?比如A1是1小时50分钟,A2是1小时40分钟,怎么相 ...答:一,如果A列数据是日期格式 =text(a1+a2,"[h]:mm")二,如果A列数据是文本格式 =text(sumproduct(--substitute(substitute(a1:a2,"小时",":"),"分钟",":00")),"[h]小时m分钟")