Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculation based on time condition

Hi experts,   I am trying to count how many meetings happens after 07:00:00PM, for that I am using the formula:   Late_Meeting = CALCULATE(COUNTX(Gilly_Meetings;[End Time])>time(19;0;0))   My E...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    I used a custom column like this:

     

    Late_Meeting = IF([Time]>time(19,0,0),1,0)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I used a custom column like this:

 

Late_Meeting = IF([Time]>time(19,0,0),1,0)