Create one formula field give name “tot_seconds”
local stringvar array completetime;
local numbervar totalseconds;
if({dtAttendance.Time}”N/A”) Then
(
completetime:=split({dtAttendance.Time},”:”);
totalseconds:= ((3600*cdbl(completetime[1])) + (60*cdbl(completetime[2]))+(cdbl(“00”)));
)
{dtAttendance.Time} time is a report field which is display time in report.
If Check In times agains chechout time not found then display ‘N/A’ and vice versa so that we haven’t calculate that time in total therefore i have to put if condition regarding this.
Now, create another formula field “totalTime”, paste below code in “edit formula” section.
WhilePrintingRecords;
NumberVar TotalSec := sum({@tot_seconds},{dtAttendance.Name});
NumberVar Hours := Truncate ( TotalSec / 3600);
NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60);
Totext ( Hours, ‘####’) + ‘:’+
Totext ( Minutes,’00’)
If you are putting “totalTime” field into grouo section it will display group wise total.
