Hello everyone,
I am currently working on a template document which gets raw data as input (time and event type) and has to count those different events in time intervals of 10 minutes. the lenghth of my measurements will always be 24hrs, with different set points. I have succeeded in making this, but a funny thing happens in the 10 minutes between 23:50:00 and 00:00:00 - if I try to change the time manually to 00:00, the problem happens with the calculations of the 10 minutes before, moreover, my set point is not constant, so using constant time values (instead the +Time (0,10,0) function) is a bit problematic...
A sheet containing the data for reference is accessible through here (it seems the uploader isn't working for me...) - https://drive.google.com/file/d/1CzN...ew?usp=sharing
Hoping there's something to do!
Thanks to anyone attempting to help~