You may try this -
create a formula in the details that will convert the HH:MI:SS in seconds.Lets call it @tot_seconds.
write this code in the formula -
local stringvar array completetime;
local numbervar totalseconds;
completetime:=split({@combinetime},":");
totalseconds:= (3600*cdbl(completetime[1])) + (60*cdbl(completetime[2]))+(cdbl(completetime[3]));
This formula will return the total seconds for every record shown in the details section.substitute your field with the @combinetime.
Summarize this field ,add a total for the above formula in the reports footer section.Now you have the total time in seconds.
we will convert back this time to the HH:MI:SS.Create a formula and put in report footer.Write the following code in the formula -
replace(cstr(floor(Sum ({@tot_seconds})/3600)),".00","")
+ ":" + replace(cstr(floor((Sum ({@tot_seconds}) mod 3600)/60)),".00","")
+ ":" + replace(cstr(floor(Sum ({@tot_seconds}) mod 60)),".00","")
The result of this formula will show the total time in the HH:MI:SS format.
Source:
The ASP.NET Forums
Quote:
Please, mark it as the solution if it helps.