Sum If Question

[ptrifile]

I think I am over thinking this but can't figure it out. I only want to SUM and show a field if it is over a certain amount of seconds. The formula field I am using to currently show this field is:

WhilePrintingRecords; 
NumberVar TotalSec :=sum({iactivitycodestat.activitytime}, {iActivityCodeStat.Timestamp},"daily");
NumberVar Hours   := Truncate  (Remainder ( TotalSec , 518400) / 3600) ; 
NumberVar Minutes := Truncate  (Remainder ( TotalSec , 3600) / 60) ; 
NumberVar Seconds := Remainder (TotalSec , 60) ;



Totext ( Hours ,   '00' ) +  ':' + 
Totext ( Minutes , '00' ) +  ':' + 
Totext ( Seconds , '00' )

Can someone point me in the right direction?

Thanks in advance!

Paul

 

[ptrifile]

Please disregard. I solved this by using the Select Expert - Group.

Paul