Data entry program stores time upon entry?

Microsoft Microsoft excel 2007 (pc)
October 3, 2010 at 22:37:53
Specs: Windows Vista
I am looking to enter data into Column A and have the time (hh:mm:ss) at which the entry was made automatically generate in the neighbouring cell in Column B. In a response to a similar question, someone suggested using a simple data entry program that stores the time upon entry but failed to give an example of what a simple program might be. I was previously entering data on a hand held Psion which is the same idea, but I no longer have access to a psion and am now using Excel 2008 for Mac. I would like to use a similar type of program instead of trying to figure out excel, so if anyone has any suggestions I would love to hear them.

In terms of excel, much of the information I am coming across in forums is in regards to a start, end and duration time, whereas I am trying to determine a rate of behaviors per second, so I have a number of data points to enter which require a corresponding time recorded to the nearest second, thus start/stop/duration aren't the main concern.

Can anyone tell me a way to do this in excel or a data entry program that will allow me to enter my data & automatically note the time at which a data point was entered into a given cell?

See More: Data entry program stores time upon entry?

Report •

October 4, 2010 at 09:05:02
If you were using Excel on Windows, we could suggest a very simple "program" written in VBA that would monitor Column A and place the current system time next to the cell that was changed.

Unfortunately, VBA was removed in Excel 2008 for MAC.

Fortunately, it is supposedly coming back in Excel 2011 for MAC.

After you upgrade, come on back and we'll help you out. ;-)

I understand that Apple Script can be used in place of VBA, but I don't know how to code in Apple Script.

Maybe a MAC forum would be a good place to ask your question.

Report •

October 4, 2010 at 12:39:08
I can get access to Excel 2007 & 2008 for PC. Can you explain how I would do this in these programs?

Report •

October 4, 2010 at 13:02:38
If you can get access to Excel 2008 for PC, you'd certainly impress me.

Where I come from, it's 2007 and 2010 for Windows...never heard of 2008.

In any case, if you right click a sheet tab, chose View Code and paste this code into the pane that opens, it will insert the time in Column B whenever you make a change to Column A of that sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Column = 1 Then _
    Target.Offset(0, 1) = Time
End Sub

If you want the Date as well as the Time, change Time to Now.

Report •

Related Solutions

October 4, 2010 at 13:45:07
Thank you SO much, you just ended two days of torture trying to figure this out!

Report •

October 4, 2010 at 14:13:48

Glad I could help.

Report •

Ask Question