Once a cell has the correct time you need to replace the function by it
value, then it is frozen:

select the cell
Edit/Copy
on the same cell
Edit/Paste Special/Value
--
Gary's Student


"confused" wrote:

HIYA
how can i lock the time in a cell when using the now function

am developing a vehicle log , and nned it to recored the time a vehicle
arives on site based on when a action is performed

example being
if a2 is activeated then b2 = time
if a3 is activated then b3 = time
ect,

the problem im having is that by using the now function all the times change
to the last entry time instead of leaving the previous times as they were