I've got data which is s follows
(Date/Time) (qty)
16/05/13 09:19:18 10
16/05/13 09:20:03 3
16/05/13 09:20:29 25
16/05/13 09:20:30 40
16/05/13 10:10:05 25
16/05/13 10:11:26 30
16/05/13 10:15:30 14
16/05/13 10:21:10 5 etc by day for 18hrs a day
I need to do a sum of the 'qty' by date/hour. So, I need 2 sums on the above data, one for 16/05/13 09* and 16/05/13 10* and then onwards through the day. Is this possible?
.png "Luminary Alumni"){kind=icon}