track the time one cell changed in another cell?

[shegotmoxie]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,

I'm trying to emulate a spreadsheet for work that we had cobbled together in excel with a vba that I never did properly understand. Now that 2008 doesn't support macros, I need to find a new way to do this. Thanks in advance for any help!

The ultimate effect was that we could track the time of entries. So, for example, I make an entry in A1, and B1 would show the current (clock) time, while C1 would show the elapsed time since the first entry. We used this to make notes during interviews that we were recording. Open a spreadsheet, and at the same time as hitting the record button, make a "start" entry. Then, as you go down column A making notes about the interview, column C creates a reference to the time stamp on the recording, and column B just stays hidden. SUPER useful, and I can imagine there are other applications for this as well. I don't care if it's ugly, but if I can't make this work, I can't upgrade! This spreadsheet is integral to our daily workflows, and the interviews are really fast-paced, so the automation helped a LOT. Any ideas?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,

I'm trying to emulate a spreadsheet for work that we had cobbled together in
excel with a vba that I never did properly understand. Now that 2008 doesn't
support macros, I need to find a new way to do this. Thanks in advance for
any help!

The ultimate effect was that we could track the time of entries. So, for
example, I make an entry in A1, and B1 would show the current (clock) time,
while C1 would show the elapsed time since the first entry. We used this to
make notes during interviews that we were recording. Open a spreadsheet, and
at the same time as hitting the record button, make a "start" entry. Then, as
you go down column A making notes about the interview, column C creates a
reference to the time stamp on the recording, and column B just stays hidden.
SUPER useful, and I can imagine there are other applications for this as
well. I don't care if it's ugly, but if I can't make this work, I can't
upgrade! This spreadsheet is integral to our daily workflows, and the
interviews are really fast-paced, so the automation helped a LOT. Any ideas?

You can use circular references to create time stamps. See

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