Log data entry time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas Guignard - 24 Jan 2007 14:43 GMT

Hi there

I'd like to have Excel log the timestamp of each row of entered data.

Example:

Data        Timestamp
4005401548638    24.01.2007 15:42
4005401548756    24.01.2007 15:43

(the first column, data, is entered using a handheld barcode scanner)

How can I achieve this?

Thanks

Signature

Thomas Guignard
Central Library
Swiss Federal Institute of Technology, Lausanne

Reply to this Message

Dave Peterson - 24 Jan 2007 15:38 GMT

I don't know if this'll work with a barcode scanner, but JE McGimpsey shows a
way when entering data manually:

http://www.mcgimpsey.com/excel/timestamp.html

> Hi there
>
[quoted text clipped - 16 lines]
> Central Library
> Swiss Federal Institute of Technology, Lausanne

Signature

Dave Peterson

Reply to this Message

Rate this thread: