Sum for minute data by Hour

[eannjones60]

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?

[#2]

Hi,

Try the function hour() and make the size by day and time.

Rebeca

[prodanov]

View this application! View dimension!

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.