Each Anipill capsule has its own internal clock. This clock is not very precise (+/-20%).
If the Sampling Interval is set to 5 minutes for example, the actual sampling interval will be different for each pill and will be somewhere between 4 and 6 minutes.
In this example, the sampling rate changed multiple times, but we can see it is not precise:
Add a column Date+Time :
Use the function 'Floor' to round the time to the preceding hour (for example, but any interval can be used):
Use a Pivot Table to average together the lines that have the same rounded time, as shown below:
And right click on a cell and select 'Ungroup':