you would need to find the nubmer of days that the work was processed on, then subtract 15 hours. DateDiff will return the number of days, and DateAdd will adjust the value.
Since I am not a running totals master, like DBlank, I would say to use shared variables: both to keep a track of the number of entries and to track the total amount of time spent for completing tickets. Then the average is simple.
shared variable formulas tend to come in groups of 3: reset, increment, & display.
reset, usually a group header:
shared numbervar x := 0;
""//hides the reset
increment, usually in detail:
shared numbervar x;
if something then
x := x + {table.field};
"" //hides the running total
display, usually a group footer:
shared numbervar x;
x
HTH
IP Logged
