I would highly appreciate help with the following example.
I have houtly data and I need to convert it to per shift data, where I have 4 shifts that start and end at specific hour:
Shift Start End
A 00:00 07:00
B 07:00 14:00
C 14:00 17:00
D 17:00 00:00
I would like to create a new table where I will see: Date / Shift / Value for the shift*
* the value for each shift is a sum of the respective hours which are included in each shift.
Attached you can find xlsx with sample data.
Thank you for your time!