adding time

[khaled]

i created an excel sheet to record the phone calls i made with the time
and i used formula time() to record the time
but when adding anyother data in to the sheet the time is updated to the
system time
and this is i don't want
i want the time fixed and not updated
so please help

 

[Satti Charvak]

You should enter the time directly as formulas get updated after, enter key ,
dbl click, f9 key etc.

 

[Mike H]

Hi,

It would help if you had posted you formula but as you have established
time() is the system time and updates when the sheet claculates.

Insert a static time with CTRL Shift ;

Mike

 

[Pete_UK]

Use <Ctrl><Shift><:> then <Enter> to put a time-stamp into a cell
(which does not vary).

Hope this helps.

Pete