Thread: adding time
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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