| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make the now() static and not change with calculation
Execllent. Thank you.
"JE McGimpsey" wrote: Check out http://www.mcgimpsey.com/excel/timestamp.html In article , "Helping with time" <Helping with wrote: I want to get a computer time if certain conditions are met using the now() function. Once the now() gives the day and time, I want to have that become static and not change even if the calculate hot key F9 is pressed. On the row, the same function will be repeated with a different time and date. Again, one that new time and date are determined by the now(), it should remain constant. The process is then repeated so that I will end up with a series of different times and dates. Can you help? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
