Hello
I am looking for some help in creating a formula which will give me the total time spent on calls during a period.
I have used the below formula to calculate the time spent on each call, but I need to sum this total but an struggling to find a solution.
NumberVar TotalSec := DateDiff ("s" ,{work_order.work_started_date_time}, {work_order.work_finished_date_time});
NumberVar Days := Truncate (TotalSec / 86400);
NumberVar Hours := Truncate (Remainder ( TotalSec , 86400) / 3600) ;
NumberVar Minutes := Truncate (Remainder ( TotalSec , 3600) / 60) ;
NumberVar Seconds := Remainder (TotalSec , 60) ;
if Days >= 1 and Hours < 24 then Totext ( Days , '00' ) + ' Days' +chr(13) + Totext ( Hours , '00' ) + ' Hours' + chr(13) + Totext ( Minutes , '00') + ' Mins'
else
if Hours >= 1 and Hours < 24 then Totext ( Hours , '00' ) + ' Hours' + chr(13) + Totext ( Minutes , '00') + ' Mins'
else
if Minutes >=0 and Hours < 1 then Totext ( Minutes , '00') + ' Mins';
Further to the above total I will then need to find the average time spent on a call so any help on this also would be appreciated.
Cheers
|