Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I don't want all NOW() cells to recalculate
Greetings,
I'm trying to save event times in an openworkbook...i.e. time of one arrival, then the next and so on. If I use NOW(), it gives me the current time (which I want), but when I take the next time, it recalculates EVERY cell so I lose the old data. Of course, I don't have time between arrivals to copy and paste values. Any ideas on how I could get Excel to return the current time in one cell while leaving past cells alone? Thanks, Nate |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I don't want all NOW() cells to recalculate
Hi Nate,
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten "Nate" wrote in message ... | Greetings, | | I'm trying to save event times in an openworkbook...i.e. time of one | arrival, then the next and so on. If I use NOW(), it gives me the current | time (which I want), but when I take the next time, it recalculates EVERY | cell so I lose the old data. | | Of course, I don't have time between arrivals to copy and paste values. Any | ideas on how I could get Excel to return the current time in one cell while | leaving past cells alone? | | Thanks, | Nate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
How do I recalculate a range of cells | Excel Worksheet Functions |