I have the below table. I would like to sum all the rows in column C (TIME GAP MINUTES) between each SHIFT_START_TIME (Column D) and group by shift start time. The dates can sometimes span over 2 different calendar dates if a user is working night shift.
I have tried using the Peek and Previous functions with no luck. Does anyone have a good solution to cumulating values?
I appreciate any help/insight. TY!
![qlik_help.png qlik_help.png](https://community.qlik.com/t5/image/serverpage/image-id/115709i51AE2226C86E695E/image-size/large?v=v2&px=999)