Hello-
I am working in a Report based on a query which seeks to report out average time between two fields, let's call them Event1 and Event2. There is another field called Class, which contains a value of A, B or C. Both of these fields are Date/Time and contain hour/min specification within the date.
In my report, I would like to list for each Class category (A, B and C) each [Event1] and [Event2] record in each, and then the average for the Class at the bottom.
Sometimes the time elapsed between Event1 and Event2 is greater than 1 day, and I want to display the average elapsed time in hours and minutes only, so that if [Event2]-[Event1] is 2 days and 10 minutes, it would display as 48:10.
Can anyone offer any advice on how to do this?
Thanks!
EBox
I am working in a Report based on a query which seeks to report out average time between two fields, let's call them Event1 and Event2. There is another field called Class, which contains a value of A, B or C. Both of these fields are Date/Time and contain hour/min specification within the date.
In my report, I would like to list for each Class category (A, B and C) each [Event1] and [Event2] record in each, and then the average for the Class at the bottom.
Sometimes the time elapsed between Event1 and Event2 is greater than 1 day, and I want to display the average elapsed time in hours and minutes only, so that if [Event2]-[Event1] is 2 days and 10 minutes, it would display as 48:10.
Can anyone offer any advice on how to do this?
Thanks!
EBox
