Hi,

Select the column of data, go to Find/Replace, in the Find type in "+00 " without the quotes, but include the space after the second zero. In the Replace - leave that blank > Press Replace All.

With the cells still selected right click and Format Cells > Custom format to hh:mm:ss.000

Then use =AVERAGE(A1:A10) to get your average of the range