I have a spreadsheet in which I am trying to count the number of tickets opened in a given time range. The column data goes from C2:C530 and it includes time data in the form of HH:MMS AM/PM. The first thing I did was changed this to 24 HR format HH:MM. I tried the following countif statement and keep getting zero returned for the result.. can someone please show me where I am going wrong with this?
COUNTIF(C2:C530,">=00:00 AND <=00:59) I tried removing the
quotes but excel didn't
like that too well.
Any help would be appreciated.
what does the A1 do in the formula below or better yet, where does it come from? Does it need quotes around each criteria? All I'm trying to do is count the number of times this column is between a given hour range.
I still haven't figured out where I'm going wrong with this function. I've tried entering it several different ways but every time it enters a "0" into the field where I want the count of the number of times data was entered whithing a certain hour range. I'm trying to get this info to utilize in a graph that shows time on one axis and a count on the other showing when the most instances occur. Any help with this function or another that would essentially do the same thing would be appreciated.