表格中多个时间，怎么提取？怎么计算平均时间？

在D2单元格中输入公式=IFERROR(IF(MIN(LEFT(SUBSTITUTE(A2,CHAR(10),""),5),MID(SUBSTITUTE(A2,CHAR(10),""),6,5),RIGHT(SUBSTITUTE(A2,CHAR(10),""),5))VALUE("12:00"),TEXT(MIN(LEFT(SUBSTITUTE(A2,CHAR(10),""),5),MID(SUBSTITUTE(A2,CHAR(10),""),6,5),RIGHT(SUBSTITUTE(A2,CHAR(10),""),5)),"hh:mm"),""),"")向右横拉至F2，再向下拉。在G2单元格中输入公式=IFERROR(IF(MAX(LEFT(SUBSTITUTE(A2,CHAR(10),""),5),MID(SUBSTITUTE(A2,CHAR(10),""),6,5),RIGHT(SUBSTITUTE(A2,CHAR(10),""),5))VALUE("12:00"),TEXT(MAX(LEFT(SUBSTITUTE(A2,CHAR(10),""),5),MID(SUBSTITUTE(A2,CHAR(10),""),6,5),RIGHT(SUBSTITUTE(A2,CHAR(10),""),5)),"hh:mm"),""),"")向右横拉至I2，再向下拉。平均上班时间G2=TEXT(SUMPRODUCT(TIME(--LEFT(D2:F4,2),--MID(D2:F4,4,2),--RIGHT(D2:F4,2)))/COUNTA(D2:F4),"hh:mm")平均下班时间K2=TEXT(SUMPRODUCT(TIME(--LEFT(G2:I4,2),--MID(G2:I4,4,2),--RIGHT(G2:I4,2)))/COUNTA(G2:I4),"hh:mm")出勤时长L2=ROUND((K2-J2)*24,2)&"小时"如图：