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

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: