I assume you are using the NOW function. Yes, that will cause the time to
change everytime the sheet is calculated. You can use teh NOW function to
first enter the time, but then you will want to immediately copy and paste
values the time so that it doesn't change. You would have to do this with a
macro if you want it to happen automatically. Put the code in the change
event of the worksheet you are using.

"Girlie Bloat" wrote:

I have set up a formula in Excel to record the time for riders in a bike race
who are doing a number of laps. Each time they come over the line I want to
put their race number in to a cell and for Excel to record the time. I have
successfully created a formula to do this (if the value of the cell into
which I put the race number is 0 the time is inserted into another cell).
However, once the time has been inserted I don't want it to change when I put
another race number in to the cell below. Does anyone know how I can do this?
Sarah