adding time

K

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
 
S

Satti Charvak

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

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
 
P

Pete_UK

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

Hope this helps.

Pete
 
D

David Biddulph

In what versions of Excel is there a function time() which gives system
time?

In Excel 2003, the time() function needs 3 parameters, hours, minutes, and
seconds.
 
Top