adding time
 

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

adding time
 

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


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"khaled" wrote:

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

adding time
 

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

"khaled" wrote:

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

adding time
 

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

Hope this helps.

Pete

On Nov 12, 11:30*am, khaled <khaled @discussions.microsoft.com wrote:
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

adding time
 

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.
--
David Biddulph

"Mike H" wrote in message
...
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

"khaled" wrote:

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