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 is over 00:00:45 and a 0 if it's equal or below that. I did use this function before however I never got a syntax error for that. Any suggestions? Thank you!

Need Help
  • 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 

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    KGBOR 

    is this what you want?

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

  • 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!