=SUMIFS(F:F,A:A,">=2018-04-01 07:30:01",A:A,"<=2018-04-01 19:30:00") EXCEL表里下拉时,日期变成 2018-04-02=SUMIFS(F:F,A:A,">=2018-04-01 07:30:01",A:A,"<=2018-04-01 19:30:00") 公式下拉时,日期自动加1天。