Forum Discussion

160475's avatar
160475
Helper I
4 years ago
Solved

multiple if

dears good day!!    i would like to creat new column that has multiple if statment see pic below    my statment would be if time commit<9:00 AM then on time  if time commit between 9:00 am...
Need Help
  • MahyarTF's avatar
    MahyarTF
    4 years ago

    Hi,

    Use the below code for creating the Column in your table :

    StatusCol = If ( time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) < time(09,00,00), "On Time",
                  if( time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) >= time(09,00,00)
                      &&
                      time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) < time(09,15,00), "Almost Late",
                      if( time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) >= time(09,15,00)
                          &&
                          time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) < time(09,30,00), "Late",
                          "After Working Houes")
                  )
                )
    then use it in your visuals.

     

    Appreciate your Kudos
MahyarTF's avatar
MahyarTF
Memorable Member
4 years ago

Hi,

Use the below code for creating the Column in your table :

StatusCol = If ( time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) < time(09,00,00), "On Time",
              if( time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) >= time(09,00,00)
                  &&
                  time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) < time(09,15,00), "Almost Late",
                  if( time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) >= time(09,15,00)
                      &&
                      time(hour(Sheet115[TimeCommit]), minute(Sheet115[TimeCommit]), second(Sheet115[TimeCommit])) < time(09,30,00), "Late",
                      "After Working Houes")
              )
            )
then use it in your visuals.

 

Appreciate your Kudos