Thats what I have going on.......but I strung them togther as I need the min, max, and avg all evaluated together (I am working with HelpDesk Tickets). I dont need the minimum day from one ticket and the minimum hour from another in the same timecode.
I need the minimum combination of "dd:hh:mm".
DateDiff ("d", {HPD_HelpDesk.Create Time},{HPD_HelpDesk.Arrival Time})
& " " &":"& (DateDiff ("h", {HPD_HelpDesk.Create Time},{HPD_HelpDesk.Arrival Time})
& " " &":"& (DateDiff ("n", {HPD_HelpDesk.Create Time}.{HPD_HelpDesk.Arrival Time})
the above equals @timeresolved
then I find
Maximum(@timeresolved) //Works
Minimum (@timeresolved) //Works
Average (@timeresolved) //Doesnt work
thanks for your patience!