Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NOW() function
If =now() fuction is used in a cell, and cell is formatted dd.mm.yy hh:mm,
time is updated every time sheet is calculated. Like this you have exact information, when latest change was done. Problem is, that it changes the time every time sheet is opened also, and data is "lost". What would be the easiest way to save the latest time when change to sheet was done ? Is it a function button, that copies only the time value to another cell or what ? -Sami |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
NOW() function
Take a look he
http://www.mcgimpsey.com/excel/timestamp.html In article , "Sami Euren" wrote: If =now() fuction is used in a cell, and cell is formatted dd.mm.yy hh:mm, time is updated every time sheet is calculated. Like this you have exact information, when latest change was done. Problem is, that it changes the time every time sheet is opened also, and data is "lost". What would be the easiest way to save the latest time when change to sheet was done ? Is it a function button, that copies only the time value to another cell or what ? -Sami |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |