![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |