二時間數據 差 (11885)

D2=TEXT(ABS(SUMPRODUCT((TEXT(LEFT(B2:C2,8),"000-00-00")+TEXT(RIGHT(B2:C2,6),"00!:00!:00"))*{1,-1})),"[HH]:MM:SS")

另解=TEXT(ABS(SUM(MMULT({1,1},TEXT(MID(B2:C2,{1;9},{8;6}),{"000!/00!/00";"00!:00!:00"})*{1,-1}))),"[HH]:MM:SS")