Forum Discussion

pagliaci's avatar
pagliaci
Frequent Visitor
4 years ago
Solved

Create shift column depending on the time

Could someone help, please? I am creating a new column that I want to display shift "1" "2" or "3" depending on the time of my production order. I tried to use

 

Turno =
/* Shift 1 6:20:00 - 14:20:00*/
/* Shift 2 14:20:01 - 22:20:00*/
/* Shift 3 22:20:01 - 06:19:59*/
IF (
HOUR ( [Hora PO] ) >= 6
&& HOUR ( [Hora PO] ) <= 14,

1,
IF (
HOUR ( [Hora PO] ) > 14
&& HOUR ( [Hora PO] ) <= 22,
2, 3))
 
But 2 things are wrong: My column "Turno" has always the value 3 and I can´t compare the minutes (in red), just full hours. I need to have the exactly shift times: 
Shift 1 6:20:00 - 14:20:00*/
/* Shift 2 14:20:01 - 22:20:00*/
/* Shift 3 22:20:01 - 06:19:59*/
 
Thank you so much!!!
  • VahidDM's avatar
    VahidDM
    4 years ago

    oops, forgot to add return in the code

     

    try this

    Measure =
Var _A= time(6,20,0)
Var _B = time(14,20,00)
Var _C = time(22,20,00)
Var _D = time(06,19,59)
return
IF (
HOUR ( [Hora PO] ) >= _A
&& HOUR ( [Hora PO] ) <= _B,

1,
IF (
HOUR ( [Hora PO] ) > _B
&& HOUR ( [Hora PO] ) <= _C,
2, 3))

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

5 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi pagliaci 

     

    Use variables:

     

    Measure =
Var _A= time(6,20,0)
Var _B = time(14,20,00)
Var _C = time(22,20,00)
Var _D = time(06,19,59)
IF (
HOUR ( [Hora PO] ) >= _A
&& HOUR ( [Hora PO] ) <= _B,

1,
IF (
HOUR ( [Hora PO] ) > _B
&& HOUR ( [Hora PO] ) <= _C,
2, 3))

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

    • VahidDM's avatar
      VahidDM
      Super User
      4 years ago

      oops, forgot to add return in the code

       

      try this

      Measure =
Var _A= time(6,20,0)
Var _B = time(14,20,00)
Var _C = time(22,20,00)
Var _D = time(06,19,59)
return
IF (
HOUR ( [Hora PO] ) >= _A
&& HOUR ( [Hora PO] ) <= _B,

1,
IF (
HOUR ( [Hora PO] ) > _B
&& HOUR ( [Hora PO] ) <= _C,
2, 3))

       

      If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

      Appreciate your Kudos!!

      • pagliaci's avatar
        pagliaci
        Frequent Visitor
        4 years ago

        It keeps getting the same error, the last column is always returning 3, even though it is morning time (1st column)..