Forum Discussion

WijnantsRMJ's avatar
WijnantsRMJ
Regular Visitor
4 years ago
Solved

Count tickets per shift

Hi all,   We're working with 3 shifts: Shift 1 starts at 7:15 until 15:15 Shift 2 starts at 15:15 until 23:15 Shift 3 starts at 23:15 until 7:15 Count the tickets for shift 1 and 2 is easy, b...
Need Help
  • WijnantsRMJ's avatar
    WijnantsRMJ
    4 years ago

    Hi, Ifound a different solution. I'm using this one which works for me: 

     

    ShiftOpenDate =
        IF(TIMEVALUE(INCIDENTS[OpenedDateTime]) >23 /24, INCIDENTS[OpenedDate] + 1, INCIDENTS[OpenedDate])
     
    Also the Night shift started on 23:00 instead of 23:15, which makes this easier.
lbendlin's avatar
lbendlin
Super User
4 years ago

two options:

- shift (pardon the pun) all times forward by 45 minutes

- add a composite key "DayPlusShiftNumber" to your data model to help identify which day shift 3 is for