excel中怎么将时间段里头的时间求和,有公式最好,工作表如下图所示答:=IF(ISERROR(RIGHT(B2,LEN(B2)-FIND("-",B2))-LEFT(B2,FIND("-",B2)-1)),0,RIGHT(B2,LEN(B2)-FIND("-",B2))-LEFT(B2,FIND("-",B2)-1))+IF(ISERROR(RIGHT(C2,LEN(B2)-FIND("-",C2))-LEFT(C2,FIND("-",C2)-1)),0,RIGHT(C2,LEN(C2)-FIND("-",C2))-LEFT(C2,...