Frequency & Time

T

Terry

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.
 
B

bpeltzer

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.
 
T

Terry

Thank you. It works great.
--
Terry


bpeltzer said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top