Average "Close" time of Problem Case

[DruciferInOk]

Crystal 8.5 for PeopleSoft 8.4

I've been asked to validate a suspicion that on person keeps their problem cases open intentionally until around 1700 HRS to avoid being assigned more cases.


I extracted the close time from the Close Date/Time field - but am not able to figure out how to average the closed time by user.


In this report I've already calculated the average amount of time open, the average business days open, the average calendar days open - just haven't been able to figure out how to average the physical close time. Help?
Thanks
Drew

 

[lbass]

First group on {table.userID} and then create a formula {@timetosecs}:

datediff("s",datetime(0,0,0,0,0,0),datetime(date(0,0,0),time({table.close})))

Then using SynapseVampire's FAQ767-3543, create another formula to place in the user group header or footer:

numberVar dur := average({@timetosecs},{table.userID});
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);
hhmmss := totext(hrs, "00") + ":" +
totext(min, "00") + ":" + totext(sec, "00");
hhmms

-LB