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
|