Trying to locate the number of hits within a range in Excel
So basically I have a spreadsheet with numerous dates/times formatted as
"1/17/2013 10:38:26 AM" with several hundred results. Basically what I
need to be able to due is determine overlapping times based on the
assumption that each time runs a duration of 2 minutes. so for instance if
there was "1/17/2013 10:38:26 AM", "1/17/2013 10:39:26 AM", and "1/17/2013
10:39:36 AM" it would say three. Essentially throughout all the times
listed for a given day I need to know the max number of calls occurring
during a 2 minute time period. Does this make sense?
No comments:
Post a Comment