Forum Discussion
Divide row by row
Hi, so I still have one problem.
I apologize if I'm not being able to explain myself well enought.
My table uses slices of five minutes. When I need a one hour slice, I need it to sum everything in that one hour slice for the Banana and Apple column and then divide them.
Example, let's use 10 minutes slices.
This is my original table
Time Banana Apple
1300-1305 1000 50
1305-1310 2000 30
1310-1315 3000 10
1315-1320 2500 20
I need something like this
Time Banana Apple
1300-1310 3000 80
1310-1320 5500 30
And then I'll do the math you suggested.
Any way to do this?
Cheers.
MarianaBotelho - did you try my last formula?
If that doesn't work I think I need some more infomation on how you change the 5 minute slicer into 10 minutes or an hours?