H1,

Right click on the cell and select Format Cells... Under the Number tab
select Custom, and choose a time format such as h:mm:ss. That should do the
trick.

Squeaky

"H1" wrote:

Hi
I have a series of timed events (races to one hundreth of a second) that
need to be tracked by event (worksheet) then all total times for teams
averaged. Right now, excel insists on translating the times into dates, so I
can't add times, let alone average them. I can't find the settings to allow
it to take time as a spam measurement rather than a date.
Help!