Forum Discussion
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 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?
I used a custom column like this:
Late_Meeting = IF([Time]>time(19,0,0),1,0)
1 Reply
I used a custom column like this:
Late_Meeting = IF([Time]>time(19,0,0),1,0)