Forum Discussion

jhaldane's avatar
jhaldane
Frequent Visitor
8 years ago
Solved

Group Days and create shifts

Please can you assist me (step by step) Please can you show me how to group into days and then create three shifts. i.e. I have many rows for the 1st May all with different times. Then group times ...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi jhaldane,

     

    Month = Test_3[Dates].[MonthNo]

Day = Test_3[Dates].[Day] 

Time = FORMAT(Test_3[Dates] ,"hh:mm:ss")

Shift =
IF (
    Test_3[Time] >= TIME ( 6, 0, 0 )
        && Test_3[Time] < TIME ( 14, 0, 0 ),
    "Shift1",
    IF (
        Test_3[Time] >= TIME ( 14, 0, 0 )
            && Test_3[Time] < TIME ( 22, 0, 0 ),
        "Shift2",
        "Shift3"
    )
)

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The problem that i am facing is that 3rd shift time overlaps between two days and the 3rd shift data has to be accounted for on the day the shift started. 
Could you please guide me on how to do that. 

  • INTEP's avatar
    INTEP
    New Member
    4 years ago

    I have facing the same problem. did get the solution?

    That means the third shift start on the day before I have selected (10:01 pm to 12:00 pm) and continues from 12:01 to 05:59 from the day selected.