Thread: [Solved] Most active time range
View Single Post
 
Old 02-07-2015, 05:21 PM
1N82I 1N82I is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2015
Posts: 3
1N82I is on a distinguished road
Default 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.
Reply With Quote