AnsweredAssumed Answered

Average Minutes Seconds Elapsed

Question asked by ShariDivido on Apr 21, 2015
Latest reply on Apr 21, 2015 by philmodjunk


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!