Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
static time in formula
I am creating a log sheet. I need the date and time to automatically enter in
cell b2 when text is entered in a2. However, once that time is entered, I do not want it to update next time I open the document. Currently, I am using the NOW function, but it updates everytime I open the document. If I go to tools, options, calculatons, I can change when Excel updates. However, I need it to update everytime I open the file, because there are other formulas in the document that must be updated. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
static time in formula
http://www.mcgimpsey.com/excel/timestamp.html
-- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "sklomstad" wrote in message ... I am creating a log sheet. I need the date and time to automatically enter in cell b2 when text is entered in a2. However, once that time is entered, I do not want it to update next time I open the document. Currently, I am using the NOW function, but it updates everytime I open the document. If I go to tools, options, calculatons, I can change when Excel updates. However, I need it to update everytime I open the file, because there are other formulas in the document that must be updated. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
Time Formula????? | Excel Worksheet Functions | |||
Need help w/ formula to sum time worked based on two values... | Excel Discussion (Misc queries) | |||
Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
time formula question... | Excel Discussion (Misc queries) |