![]() |
|
#3
|
|||
|
|||
|
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. |
| Tags |
| time |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |