Excel表格中10:30-15:30 17:30-20:00 21:00-23:45如何用函数表达出总...答:B1单元格输入公式=TEXT(SUM(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,"-"," ")," ",REPT(" ",50)),{2,4,6}*50-49,50))-TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,"-"," ")," ",REPT(" ",50)),{1,3,5}*50-49,50)),0)),"h小时m分钟")下拉公式。 如图:...