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.

Hi please post a sample sheet ( no pics pse) showing what you have and expected results. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

It's pretty straight-forward. Just pick any times that are formatted per Excel's time "13:30" format, and that's what my times look like. Example:

4:00
4:11
4:17
4:20
4:25
etc
etc

Expected results would be as I posted in the example above. So, in the above example, the most active 15 minute period might be 4:37-4:52, to use my previous example. However, I should be able to change that "15 minute" variable (call it "X") to any number of minutes, like "40", as in "what is the most active 40 minute period?" (has the greatest count of times) or most frequent data from column A.

It really would be nice if you posted a sheet. Re-typing is not my forte

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post