Frequency & Time

[Guest]

I previously asked about counting occurrences between certain times. It was
suggested that I use the "countif" formula. Unfortunately, this doesn't seem
to work. The following data was obtained using =FREQUENCY(F4:F40,G4:G10)

TIME INTERVAL FREQ.
21:30 6:00 1
17:50 8:00 0
0:50 16:30 0
18:30 20:00 3
17:30 22:00 2
20:19 23:59 0

You will notice that in the time column that there is no data between 6:00
and 8:00, yet the frequency count is 1. There is 0.50 in the time column,
that I want counted between 23:59 and 6:00. I can't figure out how to
capture this correctly.

Thanks.

 

[Guest]

Insert 0:00 as the first entry in your 'interval' column, so that 0:50 is
captured as being between 0:00 and 6:00, rather than between 23:59 and 6:00.

 

[Guest]

Thank you. It works great.
--
Terry

Insert 0:00 as the first entry in your 'interval' column, so that 0:50 is
captured as being between 0:00 and 6:00, rather than between 23:59 and 6:00.