在excel一个单元格里面取出时间的最大值和最小值,并显示在其他列,请问...答:最小值公式:=TEXT(MIN(TIMEVALUE(LEFT(C2,FIND(",",C2)-1)),TIMEVALUE(MID(C2,FIND(",",C2)+1,FIND(",",C2,7)-FIND(",",C2)-1)),TIMEVALUE(MID(C2,FIND(",",C2,7)+1,6))),"h:mm")最大值公式:=TEXT(MAX(TIMEVALUE(LEFT(C2,FIND(",",C2)-1)),TIMEVALUE(MID(C2,FIND(...