Hi All,
I'm trying to count the number of cells where the time is before or after a certain time value. The formula I'm entering right now is :
=COUNTIF(Sheet3!V:V,"<11:00:00 AM")
This is giving me "0" as a result. This is to count the number of cells where the time value is less than 11:00 a.m. However, if I change it to the below, I'm getting a clear result:
=COUNTIF(Sheet3!V:V,">11:00:00 AM")
This will give the the count of cells where the time value is more than 11:00 a.m.
FYI, I've tried changing the options to use 1904 date system just to see, but the result is the same.
Would really appreciate some help here.
ray2:
I'm trying to count the number of cells where the time is before or after a certain time value. The formula I'm entering right now is :
=COUNTIF(Sheet3!V:V,"<11:00:00 AM")
This is giving me "0" as a result. This is to count the number of cells where the time value is less than 11:00 a.m. However, if I change it to the below, I'm getting a clear result:
=COUNTIF(Sheet3!V:V,">11:00:00 AM")
This will give the the count of cells where the time value is more than 11:00 a.m.
FYI, I've tried changing the options to use 1904 date system just to see, but the result is the same.
Would really appreciate some help here.
ray2: