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.
WijnantsRMJ's avatar
WijnantsRMJ
Regular Visitor
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.
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi WijnantsRMJ ,

Glad you solve the problem by yourself! You can mark your answer as the solution. Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

 

Best Regards,
Community Support Team _ kalyj