Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-07-2015, 05:21 PM
1N82I 1N82I is offline Most active time range Windows 7 32bit Most active time range Office 2010 32bit
Novice
Most active time range
 
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
 

Tags
time



Similar Threads
Thread Thread Starter Forum Replies Last Post
Most active time range date & time of last time a recent file was used pgeorgilas Word 1 10-31-2014 08:59 AM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Most active time range Active row number ArviL Excel 3 04-15-2013 04:00 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Active Directory nukkumatti Misc 0 11-16-2005 08:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft