=TEXT(SUM(--(IF(ISERR(FIND("小",A1:A14)),"0:","")&IF(ISERR(FIND("分",A1:A14)),"0:","")&SUBSTITUTE(SUBSTITUTE(LEFT(A1:A14,LEN(A1:A14)-1),"分",":"),"小时",":"))),"[h]小时M分S秒")
公式以CTRL+SHIFT+回车三键结束。
=text(sumproduct(--("0:"&substitute(substitute(a1:a10,"分",":"),'秒",")))'"[m]分s秒")
http://tieba.baidu.com/f?kz=750454948
请参考此贴
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024