I was able to claculated the amount of time that has elapsed between events (stored in the Db as Date/Time format) by using something like
TimeValue ({end time} - {start time})
So I have these 73 items in the details that now appear in a time format (0:37:14 for 37 minutes 14 seconds), but I want to be able to find the average of the the 73 record's elapsed times. I tried to insert summary, but the Average option is not listed.
I am thinking it is not listed because I am not dealing with numbers, but rather a date/time field. I am also thinking that my next step should be to convert the time-formatted fields back into a number, obtain the avrerage and then convert the average in the summary back into a time format so that it doesn't read as a number.
What is the easiest way to do this? Is there an easier way to obtain the same goal that I am overlooking? Thanks for your help.
AJC
TimeValue ({end time} - {start time})
So I have these 73 items in the details that now appear in a time format (0:37:14 for 37 minutes 14 seconds), but I want to be able to find the average of the the 73 record's elapsed times. I tried to insert summary, but the Average option is not listed.
I am thinking it is not listed because I am not dealing with numbers, but rather a date/time field. I am also thinking that my next step should be to convert the time-formatted fields back into a number, obtain the avrerage and then convert the average in the summary back into a time format so that it doesn't read as a number.
What is the easiest way to do this? Is there an easier way to obtain the same goal that I am overlooking? Thanks for your help.
AJC