Countif不适用于小时和/或日期

本文介绍了Countif不适用于小时和/或日期的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我在3列中有数据:

A.目的地(例如洛杉矶)B.承运人(例如Ups)C.发货时间(例如4:00)

A. Destination (es. LosAngeles) B. Carrier (es. Ups) C. Shipment Time (es. 4:00)

使用的时间是没有Am/Pm的24小时时间

The time used is the 24h time without Am/Pm

我需要做点事才能知道我们在特定时间有多少个货件.

I need to do a countif to know how many shipments we have at a specific time.

尝试过:= COUNTIF(A1:A100，> ="& TIME(8,30,0))-COUNTIF(A1:A100，>"& TIME(9,0,0)结果0

Tried with: =COUNTIF(A1:A100,">="&TIME(8,30,0))-COUNTIF(A1:A100,">"&TIME(9,0,0) Result 0

尝试过:= COUNTIFS(A1:A100，> = 8:30"，A1:A100，"<= 9:00")结果0

Tried with: =COUNTIFS(A1:A100,">=8:30",A1:A100,"<=9:00") Result 0

尝试过:= COUNTIF('sheet1'！I:I，< ="& TIME(4，0，0))结果0

Tried with: =COUNTIF('sheet1'!I:I,"<="&TIME(4, 0, 0)) Result 0

有帮助吗?预先谢谢你.

Any help? Thank you in advance.

推荐答案

尝试:

=COUNTIFS(A1:A100,">="&TIME(8,30,0),A1:A100,"<="&TIME(9,0,0))

下面的公式末尾缺少右括号

The formula below was missing a closing bracket at the end

=COUNTIF(A1:A100,">="&TIME(8,30,0))-COUNTIF(A1:A100,">"&TIME(9,0,0))