Excel 2010: hh:mm Excel adding seconds I've not input

[Paddington1881]

Hi Board

I have a list of times entered manually. The cells are custom formatted as hh:mm. When I click on a cell, the result is shown in the formula bar as hh:mm:ss but the seconds are always zero. That's as expected since I only ever input the times as hours and minutes (never seconds).

Problem is when I calculate averages I'm getting slightly different times, and I've found that some of my times are being recorded as having seconds even though I've never entered seconds. I think all those seconds are causing the discrepancies.

Reformatting to hh:mm hasn't worked. Does anyone know how Excel can come up with seconds when they've not been input please?

Thanks as always.

Darren

 

[eduzs]

Please, tell some examples of the problem, the data you have, the calculation done, the expected value and the returned result.