Set a timestamp function in Excel to force an exact time into a cell
I have added a dedicated webpage to explain the timestamp attendance sheets use and creation. see http://twict.net/excel-timestamping
A new addition The Ultimate Attendance sheet :-) can be found at • Ultimate attendance spreadsheet
If you need to get an automatic timestamp on entry into a cell the now command is useful but it then changes every time another cell is updated. If you need to hold onto the timestamp for each cell then you need this routine with iteration set on. This is useful for recording attendance. ### sample file available at http://fs.50webs.com/files/attendance... . Also to do this on a Mac see • time stamp function in excel on a Mac usin...
If you get a circular reference warning it means you haven't got the iterations options ticked in the Formula section of Excel options. Make sure you tick it. You may need to do that again in the future if Excel updates in the background. see also • Excel recording of attendance using iterat...