Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Adding | Excel Discussion (Misc queries) | |||
Adding Time | Excel Worksheet Functions | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding Time | Excel Worksheet Functions | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |