Forum Discussion
Solved
Split start time and end time into multiple rows based on shift
Hi, I'm trying to achieve the transformation below. I tried multiple things but they quickly became overly complicated. I hope you can help. My sample data: Id Start Time End Time ...
try this and let's know
try this and let's know
It works 0K
I tried to modify it to work with shifts like this:
Shift 1 => 07:00 - 15:00
Shift 2 => 15:00 - 23:00
Shift 3=> 23:00 - 07:00 (next day)
but couldn't find the solution,
Can you, or someone, help, please?
Thanks