起止時間 各區段幾分鐘 (13878)

F3:I7{=SUM(FREQUENCY(ROW(INDIRECT(TEXT($C3,"H:M")*1440+1&":"&TEXT($D3,"H:M")*1440)),$M$3:$M$11*1440)*($L$2:$L$11=F$2))



留言