第1个回答 2012-03-13
=SUM(IF(A1:A2="",0,VALUE(MID(A1:A2,1,IF(ISERROR(FIND(" ",A1:A2)),LEN(A1:A2),FIND(" ",A1:A2)-1)))))+INT(SUM(IF(A1:A2="",0,IF(ISERROR(FIND(" ",A1:A2)),0,VALUE(MID(A1:A2,FIND(" ",A1:A2)+1,LEN(A1:A2)-FIND(" ",A1:A2)))))))&" "&TEXT(MOD(SUM(IF(A1:A2="",0,IF(ISERROR(FIND(" ",A1:A2)),0,VALUE(MID(A1:A2,FIND(" ",A1:A2)+1,LEN(A1:A2)-FIND(" ",A1:A2)))))),1),"HH:MM:SS")
同时按CTRL+SHIFT+回车,公式前后自动生成{}号,就好了,设你的两个数据在A1和A2中。