How to group values related to each minute

Dear experts,

I have a table in format below, I want show a third column with sum of w.r.t the minute, so for time 2:10 ,

i want to show 10 which is sum of first four values. Can you lease guide me how i can do it.

Thanks.


Started DB request
2:10:00 2
2:10:11 3
2:10:11 4
2:10:13 1
2:11:10 3
2:11:11 2
2:11:12 1
2:12:10 1
2:12:12 2
2:12:12 2
2:12:13 1
2:13:11 1
2:13:12 1

Originally Posted by judgeh59

I went with grouping in a pivot table....I hope this helps....

Thank you it helped. But not sure why it does to me when I group with time.
When I grouped pivot table. I see its formatted with seconds, its sum 2:10:11 , 2:10:12 values.


Also, how can I give a star.

worked for me thanks