Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I make "NOW" function static
I am trying to create a time study template. I want to use "NOW" function on
multiple rows so that I can get the different stamps for the activities i amrecording. How Do i do it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I make "NOW" function static
To do this manually, A)Select 2 cells, format cells as Date Time in desired
format you prefer. B) Select 1st cell and enter the "=now()" formula, C) hit f9 to update, and copy this cell; select 2nd cell and paste special values. Copy 2nd cell D) and paste to desired cell. To set up as a macro, record the macro for the activity from A) to D). When you run the macro it will put the current date and time stamp into memory and you can paste this into any cell you want. You can then clear the contents from the first two cells to keep your worksheet clean. If you really want to keep it, remember that this is a one time only type of macro and the first cell's results will only change if you leave the original now formula intact. I would clean it up since it just leaves something there that might cause a mistake. If you need to make a macro in Excel 2007, make sure the developer tab is showing. To make the developer tab show choose the Office Button and choose Excel Options on the bottom of the drop down, check the Show Developer tab in the ribbon. "chineshg" wrote: I am trying to create a time study template. I want to use "NOW" function on multiple rows so that I can get the different stamps for the activities i amrecording. How Do i do it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I make "NOW" function static
Check this link for a variety of options:
http://www.mcgimpsey.com/excel/timestamp.html Hope this helps, Hutch "chineshg" wrote: I am trying to create a time study template. I want to use "NOW" function on multiple rows so that I can get the different stamps for the activities i amrecording. How Do i do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make the INFO("directory") function work? | Excel Worksheet Functions | |||
Can you make a cell = 0 if original function is creating a"#ref!"? | Excel Worksheet Functions | |||
How to make number of "static" fields stay the same when copying? | Excel Discussion (Misc queries) | |||
can i make a "repeat until" kind of function in excel2003 | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) |