I have these values
01:15 05:00 01:31 02:00 02:21 02:39 03:29 08:00
I highlighted all these cells and went to format cells -> custom -> and choose mm:ss
I then tried to use the built in average function in Excel 2007
The result is 0.0
Of course this is not the number result that it should be(I have not calculated it manually yet but I am sure it is not 0).
I am not sure if it has the fact to do when you click on the cell it has something like this
I am not sure if that is what is screwing it up.