Frequency & Time
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. -- Terry |
Frequency & Time
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. "Terry" wrote: 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. -- Terry |
Frequency & Time
Thank you. It works great.
-- Terry "bpeltzer" wrote: 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. "Terry" wrote: 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. -- Terry |
All times are GMT +1. The time now is 12:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com