Wednesday, 11 September 2013

Trying to locate the number of hits within a range in Excel

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