castingchick101
New Member
- Joined
- Jun 11, 2019
- Messages
- 2
I have a table with some timestamps and some values. I need to group the data based on the time difference between datapoints - for example if the time difference between two points is greater than 3 days, put data in a new group.
I have tried using a pivot table for this but can only group by time interval (day, month, etc..), not by time difference.
TY
I have tried using a pivot table for this but can only group by time interval (day, month, etc..), not by time difference.
TY