Forum Discussion
average in duration of time
How do I take an average of a time duration. Every time I use the average formula it gives me an error message. For example elapsed time of 1:31, 2:14, 3:23 and 0:34. What formula would I use to get an average of these that comes out in the correct time format?
If each time value is in a separate cell, the AVERAGE function should do what you want:
If the format of the cell with the formula is not correct, you can either apply the correct format manually, or use the Format Painter button on the Home tab of the ribbon to copy the format of one of the input cell to the formula cell.
Are the values in N4:N304 entered manually or are they the result of formulas? If the latter, what do these formulas look like?
