Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency and Time | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions |