字符時間差 (13354)

C2=TEXT(MOD(MID(B2,FIND("-",B2)+1,9)-LEFT(B2,FIND("-",B2)-1),1),"H:MM")

另解=TEXT(MOD(SUM(TRIM(MID(SUBSTITUTE(B2,"-",REPT(" ",19)),{1,19},19))*{-1,1}),1),"H:MM")



留言