Average Minutes Seconds Elapsed
Hi, hoping someone can help me with a calculation to average the amount of time in minutes and seconds elapsed. Here is the scenario: I have multiple fire drills entered as one record each with a start and end time and a calculation (end time - start time) for "elapsed time". Now I need to get an average of time elapsed.
I have a field to count the number of drills and a summary field to get the total of the elapsed time. Should I not just be able to create a field that divides the sum of the elapsed time by the number of drills? Time is tricky and I don't think I am quite getting this right.
Any help you can give is appreciated. Thanks!