Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try the function hour() and make the size by day and time.
Rebeca
View this application! View dimension!
Hi,
Please find attached file for solution.
Regards,
Jagan.