Forum Discussion

KGBOR's avatar
KGBOR
Helper I
3 years ago
Solved

IF function with time column

Hello, I'm stuck at a probably pretty simple issue with the IF function. I have a column in time format (hh:mm:ss) and what I want to do with it is to create another where I get a 1 whenever the time...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    KGBOR 

    is this what you want?

    Column = if('Table'[Column1]>time(0,0,45),1,0)

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,
    Have you tried using IF((["Date column"])>TIME(00,00,45),1,0)?


    I hope that helps 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,
Have you tried using IF((["Date column"])>TIME(00,00,45),1,0)?


I hope that helps 

KGBOR's avatar
KGBOR
Helper I
3 years ago

Indeed it did! Thank you! Is there any specific reason why it only works with the TIME function? I've used it with other time formatted columns (e.g. for deductions) and I did not have to use this additional function. Thanks again!