average in duration of time

[Kevinj1975]

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?

[#2]

@Kevinj1975 

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.

[#3]

Here is what I am working on and it just keeps giving me this error message. @HansVogelaar 

[#4]

@Kevinj1975 

Are the values in N4:N304 entered manually or are they the result of formulas? If the latter, what do these formulas look like?

[#5]

They were exported from a report that I ran. They came out in a general format under the number tab. @HansVogelaar 

[#6]

@Kevinj1975 

Select N4:N304.

On the Data tab of the ribbon, click Text to Columns.

Select Delimited, then click Finish.

Does the formula work now?

[#7]

Yes it finally works, thank you very much for your help with this.