Calculating average of dynamic table column created using select TIMEDIFF

[stevem]

Please help.

 

I am querying a database that has two datetime fields and other infomation.

In the select statement I use the TIMEDIFF to calculate the difference and create a virtual field.

 

When the dynamic table is displayed I then wish to calculate the average of the virtual time diff fields.

the time diff field is in the HH:MM:SS format.

 

Hope I have explained okay.

 

Thanks