Hi Every one and thanks in advance for any help you can give
Per the attached file or sample data
I would like to group column C (time) in 5 min time intervals and count the amount of values in column D(code) for each 5 min time period
So from 0:38 to 3:04 falls within the first 5 min period and has a count of 7 ( 100 value ) and so on
site Date Time Code
4 3/18/2014 00:38.0 100
4 3/18/2014 00:46.0 100
4 3/18/2014 01:50.0 100
4 3/18/2014 02:14.0 100
4 3/18/2014 02:25.0 100
4 3/18/2014 02:37.0 100
4 3/18/2014 03:04.0 100
4 3/18/2014 05:39.0 100
4 3/18/2014 05:53.0 100
4 3/18/2014 05:58.0 100
4 3/18/2014 06:32.0 100
4 3/18/2014 13:42.0 100
4 3/18/2014 14:36.0 100
4 3/18/2014 17:06.0 100
4 3/18/2014 28:22.0 100
4 3/18/2014 28:33.0 100
4 3/18/2014 28:43.0 100
4 3/18/2014 29:00.0 100
4 3/18/2014 30:43.0 100
4 3/18/2014 51:43.0 100
4 3/18/2014 51:51.0 100
4 3/18/2014 52:16.0 100
4 3/18/2014 52:27.0 100
4 3/18/2014 21:11.0 100
4 3/18/2014 22:35.0 100
4 3/18/2014 24:13.0 100
4 3/18/2014 25:50.0 100
4 3/18/2014 26:06.0 100
4 3/18/2014 28:15.0 100
4 3/18/2014 12:49.0 100
4 3/18/2014 13:51.0 100
4 3/18/2014 13:58.0 100
4 3/18/2014 14:46.0 100
4 3/18/2014 15:36.0 100
Bookmarks