Flooring timestamp to minutes mystery (Have solution that doesn't quite work)

Having a very long list of timestamps with seconds presicion I want to sum the value for each minute.

I found a solution in this link, but the implementation fails on most of my value.

If I correct my written value of my "Minutes for SUMIF" manually, I get results, but my array of needed minutes are much too long for that. I tend to believe it's some sort of rounding error, but displaying the time values as numbers does not show any.

What could cause this mystery and how can I help it?

Thanks in advance,


Gregers_DK

Try this formula

=SUMPRODUCT($B$2:$B$25921,--(ROUND($C$2:$C$25921,6)=ROUND(E2,6)))

I never thought about using the cumulative values! Thanks!

Gregers_DK

I should note, that I used the solution from shg after making a correction:

While he has the idea right, I did not manage to use the latter part (SUM($E$1:E1)) correctly, for reasons unknown. Instead I rewrote this part, so the formula now is as underneath.
For E2

Formula:

Please Login or Register  to view this content.

Technically it should do the same, but it now works with just samples of the data.


Gregers_DK