總計 時 分 秒數 (15280)

C2:E6=INDEX(TEXT($B2,{"[MM]","[SS]","[SS]"})/{60,60,1},COLUMN(A1))

C2:E2區域數組公式 下拉{=TEXT(B2,{"[MM]","[SS]","[SS]"})/{60,60,1}