=TEXT(INT(SUM((IF(ISERR(LEFT(A2:B2,FIND("天",A2:B2)-1)*{24,-24}),LEFT(A2:B2,LEN(A2:B2)-2),LEFT(A2:B2,FIND("天",A2:B2)-1)*{24,24})+IF(ISERR(MID(A2:B2,FIND("天",A2:B2)+1,LEN(A2:B2)-FIND("天",A2:B2)-2)),0,MID(A2:B2,FIND("天",A2:B2)+1,LEN(A2:B2)-FIND("天",A2:B2)-2)))*{1,-1})/24),"[>0]#天;")&TEXT(MOD(--(0&TEXT(SUM((IF(ISERR(LEFT(A2:B2,FIND("天",A2:B2)-1)*{24,-24}),LEFT(A2:B2,LEN(A2:B2)-2),LEFT(A2:B2,FIND("天",A2:B2)-1)*{24,24})+IF(ISERR(MID(A2:B2,FIND("天",A2:B2)+1,LEN(A2:B2)-FIND("天",A2:B2)-2)),0,MID(A2:B2,FIND("天",A2:B2)+1,LEN(A2:B2)-FIND("天",A2:B2)-2)))*{1,-1}),"[>0];")),24),"[>0]#小时;")
来的太晚了啊!收获不小 |