Forum Discussion

ANerat's avatar
ANerat
Regular Visitor
5 years ago
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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

try to adapt and see what is appening .

replace "08" with "12".

consider that where there is a product of 3 it is, in effect, of 24/8. In the hypothesis of two shifts of 12 hours, 24/8 becomes 24/12 = 2.

 

Regarding the explanation, it depends on your level of knowledge.

I can explain the basic idea of the solution or even the implementation details (there are also possibilities of different solutions using the List.generate function).

 

If you try to study it and then say where it is not clear to you, perhaps the explanation could be more effective.

ANerat's avatar
ANerat
Regular Visitor
5 years ago

Thanks for your explanation. I'm not too familiar with M but so far I can follow the transformations. Accepted as solution.

  • LaSof's avatar
    LaSof
    New Member
    2 years ago

    Hi ANerat,

    Did you manage to set the function to work with two shifts of 12 hours?