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?
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.
I can get access to Excel 2007 & 2008 for PC. Can you explain how I would do this in these programs?
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 SubIf you want the Date as well as the Time, change Time to Now.
Thank you SO much, you just ended two days of torture trying to figure this out!
Anytime. Glad I could help.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |