Most active time range
I've got some time data in column A (formatted as time "13:30") and need to find the most frequent "X" (minutes) time period, where I can change the "X" to any number of minutes. An example might be if I have to know "what's the most active 15 minute period within that data?" These periods could fall anywhere within the hour, so, in this example, the most frequent 15 minute period (where each time represents a "count") could theoretically be 4:37-4:52. I'm not sure if would be array type of thing because it would have to go through all the data points in column A and create various simulated 15 minute periods and ask the question, "Which 15 minutes is the most active (has the greatest count or number of values in Column A)?" Kind of like looking for clusters if I were putting it on a chart.
|