Thread: adding time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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