Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Writing IF Statement Formula

Hi All,   I have a column that contains (formated as time) minutes. I am trying to writie an If statement like this: If (column that contains minutes) is less than 30 minutes, then "YES" otherwise ...
Need Help
  • SethuPower's avatar
    SethuPower
    6 years ago

    Below should help to convert hour to minutes and compare in IF statement

     

    IF( HOUR(Table1[Column1]) * 60 + MINUTE (Table1[Column1]) <=30,"Yes", "No")

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The minutes column looks like this example 0:14,1:05, etc.

This is how I tried writing the formula: If(Column name<=("0:30"), "Yes", "No")).

 

Hope this explains it clearly.

 

Thanks

SethuPower's avatar
SethuPower
Frequent Visitor
6 years ago

Below should help to convert hour to minutes and compare in IF statement

 

IF( HOUR(Table1[Column1]) * 60 + MINUTE (Table1[Column1]) <=30,"Yes", "No")

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I just used your suggested formula and it worked like magic.

     

    Many thanks for the quick solution.

     

    Regards

     

     

    • SethuPower's avatar
      SethuPower
      Frequent Visitor
      6 years ago

      Pls mark this as a solution :smileyhappy: