時間總和 (14197)

D2=TEXT(SUMPRODUCT(TEXT(LEFT(B2:B9&"0000000",6),"00!:00!:00")*1),"[H]:MM:SS")

F2:F9=IF(B2="","",TEXT(LEFT(B2&"0000000",6),"00!:00!:00"))

H2=TEXT(SUMPRODUCT(F2:F9*1),"[H]:MM:SS")