excel表格带文字自动求和
发布网友
发布时间：2022-04-24 12:26
共1个回答
热心网友
时间：2023-10-12 19:52
参考此公式=SUMPRODUCT(--LEFT(A1:A4,FIND("天",A1:A4)-1))+INT(SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(MID(A1:A4,FIND("天",A1:A4)+1,10),"小时",":"),"分","")))&"天"&TEXT(MOD(SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(MID(A1:A4,FIND("天",A1:A4)+1,10),"小时",":"),"分","")),1),"h小时m分")
