Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have each activity with a start_time and a end_time. I'm trying to calculate the number of activities finished within 10 minutes. How should I write the function?
Should be something like:
COUNT({<(End_Tme-Start_Time)={"<=00:10:00"}>}ACTIVITY)
Thanks in advance!
Hi Wanyun,
Try this:
=COUNT({<Interval(End_Time-Start_Time)={"<=interval('00:10:00')"}}ACTIVITY)
(I didn't tested).
G.