求教.xlsx 不同日期里小时数相加公式?感谢!答:先计算两个时间之差,公式=IF(ISNUMBER(FIND(":",RIGHT(B2,LEN(B2)-FIND("-",B2)-1))),TIME(LEFT(RIGHT(B2,LEN(B2)-FIND("-",B2)-1),FIND(":",RIGHT(B2,LEN(B2)-FIND("-",B2)-1))-1),RIGHT(RIGHT(B2,LEN(B2)-FIND("-",B2)-1),FIND(":",RIGHT(B2,LEN(B2)-FIND("...