Hello all!
I hope this isn't one of those forever re-posted questions, but I have spent a couple of days looking over the archives on this site, as well as experimenting with Excel 2007, and am coming up a bit short.
Simply put, I would like to take a column of date/time strings, for example
1/6/2010 12:01
and create a series of ranges, for example 1/6/2010 12:00 - 1/6/2010 12:05, and sum the number of input times that appear in each of the 5 minute ranges. I've seen a variety of postings on this topic, but none that I've been able to put together to really nail this.
I have been experimenting with "Data Analysis" tab in Excel, and do have all my date input cells created as actual date/times (=ISNUMBER(CELL) = TRUE), but everything currently seems to land in my last bin, not distributed.
Again, my apologies for being redundant, but would sure appreciate any guidance! Thanks all!
--Steve
I hope this isn't one of those forever re-posted questions, but I have spent a couple of days looking over the archives on this site, as well as experimenting with Excel 2007, and am coming up a bit short.
Simply put, I would like to take a column of date/time strings, for example
1/6/2010 12:01
and create a series of ranges, for example 1/6/2010 12:00 - 1/6/2010 12:05, and sum the number of input times that appear in each of the 5 minute ranges. I've seen a variety of postings on this topic, but none that I've been able to put together to really nail this.
I have been experimenting with "Data Analysis" tab in Excel, and do have all my date input cells created as actual date/times (=ISNUMBER(CELL) = TRUE), but everything currently seems to land in my last bin, not distributed.
Again, my apologies for being redundant, but would sure appreciate any guidance! Thanks all!
--Steve
