Code: Select all
IF(ISBLANK(B12); " ";NOW())
Code: Select all
IF(ISBLANK(B12); " ";NOW())
The macro to insert the time stamp into the active cell can be found under MyMacros/pyCalc/NowToCalcCell/NowToActiveCell. Assign a keyboard shortcut to it or a button or a menu entry. It inserts the current date-time value down to milliseconds, leaving the formatting up to you. When used with a cell having the default number format, the macro applies the default date-time format.Download the Writer document to a trusted directory allowing execution of embedded macros and push the install button. See Tools --> Options --> Security, button [Macro Security]. There you choose the highest security level and add one or more directories where you store trusted documents like this one. This must not be your default directory for downloads because this directory gets anything downloaded from the internet. You should explicitly move your trusted documents into trusted directories.