activities finished within 10 minutes

[wanyunyang]

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!

[undergrinder]

Hi Wanyun,

Try this:

=COUNT({<Interval(End_Time-Start_Time)={"<=interval('00:10:00')"}}ACTIVITY)

(I didn't tested).

G.