Thread: adding time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Satti Charvak[_2_] Satti Charvak[_2_] is offline
external usenet poster
 
Posts: 53
Default 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