Calculation based on time condition

[Anonymous]

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 End Time column format is like:

17:00:00

15:00:00

21:00:00

However the formula keep showing True as result. Any suggestions?

[Greg_Deckler · Accepted solution]

I used a custom column like this:

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