local numberVar RemainingSeconds;
local numberVar Hours;
local numberVar Minutes;
local numberVar Seconds;

Hours := Truncate (({@average seconds})/3600);
RemainingSeconds := ({@average seconds}) - (Hours*3600);
Minutes := Truncate ({@average seconds}/60);
Seconds := ({@average seconds}) - (Hours*3600) - (Minutes*60);

totext(Hours,"00") + "hrs " +
totext(Minutes,"00") +"mins " +
totext(Seconds,"00") +"secs ";

 

As you can see they are averaged times.

I now have to sum these averaged fields for subtotals per record.

How can I do this ?

Do I convert each field back to seconds, sum then convert back to hh, mm, ss format ?

Proving really tricky due to the averaging of  the times.

Thanks