ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Timestamp function that does not update in Excel? (https://www.excelbanter.com/excel-worksheet-functions/14947-timestamp-function-does-not-update-excel.html)

Guard823

Timestamp function that does not update in Excel?
 
Is there any way to make Excel timestamp a cell without it updating to the
current time when saved? This function will be used up to hundreds of times
a day for logged entries on a computer.

Dave Peterson

So if you change something in column A (say), you want the date/time in column
X???

If yes, you may want to look at how JE McGimpsey does it:
http://www.mcgimpsey.com/excel/timestamp.html

Guard823 wrote:

Is there any way to make Excel timestamp a cell without it updating to the
current time when saved? This function will be used up to hundreds of times
a day for logged entries on a computer.


--

Dave Peterson


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com