两者之间的差额间隔 (9598)

D3=TEXT(INT(IF(C3>B3,C3-B3,B3-C3))*SIGN(B3-C3),"0天前 ;0天后 ;当天 ")&IF(C3-B3<0,"-","")&TEXT(IF(C3>B3,C3-B3,B3-C3),"HH:MM:SS")

另解=TEXT(INT(C3-B3)+(C3-B3<0),"0天后 ;0天前 ;当天 ")&REPT("-",C3<B3)&TEXT(ABS(C3-B3),"hh:mm:ss")

另解=TEXT(ABS(C3-B3),LOOKUP(C3-B3,{-99,-0.999999,0,1},{"D天前 -","当天 -","当天 ","D天后 "})&"hh:mm:ss")

另解=TEXT(TRUNC(C3-B3),"0天后;0天前;当天")&TEXT(C3-B3," ; -; ")&TEXT(ABS(C3-B3),"hh:mm:ss")