consultingrelop.blogg.se

You can assign a shortcut or a button to this macro, by applying the methods provided in that article.Save the macro, following the steps described in Using Macros.Give this macro a name, for example TimeStamp.In the Record Macro window, click on Stop Recording.In the warning dialog which opens, click Yes.In the Paste Special window which appears, uncheck all boxes except Strings.Choose Paste Special… in the Edit menu, or press the Shift-Command-V keys.Choose Copy in the Edit menu, or press the Command-C keys.To display the date and time in 02/15/08 10:30:35 format, or choose the format you wish. Select the cell which is to display the fixed timestamp.Choose Record Macro in the Macros sub-menu of the Tools menu.Select Date and Time in the Category section to display all the available formats.In a Calc document go to the Format menu then choose Cells… and click on the Numbers tab.In order to know all the available date and time formats: Sometimes, however you need to fix a date, for example to calculate the time which was necessary to perform a task. Then select your style of choice and anycodings_openoffice-calc click OK.When you insert date and time in a Calc document by using the NOW() function, this data is updated every time you click on Recalculate in the Cell Contents sub-menu of the Tools menu and every time you open your document again after having saved it. Next select your 60 or so cells, Format anycodings_openoffice-calc > Conditional Formatting… anycodings_openoffice-calc and for Condition1 select Formula is and anycodings_openoffice-calc enter: WEEKDAY(A1 4)>4 Then anycodings_openoffice-calc click on the fill handle (the small anycodings_openoffice-calc black square at the bottom right-hand anycodings_openoffice-calc corner of the cell) of cell A1 and drag anycodings_openoffice-calc down to suit (for two months about 60 anycodings_openoffice-calc rows). Then Format > Cells > Numbers Date anycodings_openoffice-calc and 31/Dec/1999, and click OK. I am assuming capitalisation of the anycodings_openoffice-calc whole of the month short name is not anycodings_openoffice-calc critical as arranging that would anycodings_openoffice-calc complicate meeting the rest of your anycodings_openoffice-calc requirements. Thank you for choosing a date that is anycodings_openoffice-calc independent of locale (ie dd = MM).