|Subject:||Countif time syntax|
|Posted by:||RJG (no_ma…@nomail.biz)|
|Date:||Thu, 26 Mar 2009|
I have a worksheet with time entries (formatted as date/time cells) and
I want to count how many entries are between certain hours - i.e. how
many are from 1p to 2p, from 2p to 3p etc.
I understand the syntax as =countif(range,criteria)
I am having trouble figuring out how to enter the criteria for the time
i.e. countif(d2:d366,>13:00<14:00)does not work,
nor does countif(d2:d366,">13:00<14:00")
can anybody help with the syntax?