How do I time stamp cells to match points in a teacher's audio lecture? Student needs help

**gnobles** · 01-07-2013, 02:10 PM

I'm using Excel 2010 on Windows 7. I'm a student trying to take notes in Excel cells with each cell having a time stamp from a zero time mark. I am using an audio recorder to record a lecture. The time stamps start at 00:00 minutes and seconds (not with the current time/date). A new time stamp appears when a new cell of typed data is created in Column B under the last Cell that was entered.
I want the notes I take in Excel cells to correspond with key points that my teacher makes on the audio recording.

Example
Column A Column B
00:00 Mr. Jones starts his lecture with slide show
02:30 The slide show ends and Mr. Jones defines the definition of necrofasciitis
02:48 Diseases that can affect every muslce and joint in the body include....
05:32 The lists you need can be found on page 727

So I need Column A to have time stamps next to each cell in column B where I enter a new point made by my instructor. Those time stamps are entered automatically from a zero minute, zero second start point, when I start typing in a new cell in column B.

My goal is to match the points made in an audio lecture to the time stamps and corresponding notes in my excel spread sheet.

Does anyone know how to do this? Or, can you point me to an excel expert I could consult?

Thank you very much for any help you can offer.

Gabriel

**swoop99** · 01-08-2013, 05:27 AM

Try this in the worksheet_change event of the sheet you're working on:

Please Login or Register  to view this content.

If you're making notes in column A going downwards, for example, every time you enter new text into a cell Excel will put the current time in column B of the same row.

**gnobles** · 01-08-2013, 10:22 AM

Thank you for responding swoop99. I pressed Alt F11 to enter the data you provided. I double clicked on worksheet 1 and then entered the following into the blank white page:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Cells(Target.Row, 2).Value = Time
End Sub

I'm not sure what to do after that. I really have very little idea how to make this work, but I'm still searching all over the internet for detailed instructions.

**swoop99** · 01-08-2013, 12:13 PM

That should be it. You may need to ensure macros are enabled and that events are turned on.

To ensure events are on: create a new module and put this code in:

Please Login or Register  to view this content.

and then run it. Nothing will happen but event detection is now on. Then try typing something into a cell on worksheet 1 (NOT in column B) and see if a time stamp appears in column B. You may need to click in another cell or press enter to trigger the change event.

How do I time stamp cells to match points in a teacher's audio lecture? Student needs help

LinkBack

Thread Tools

Rate This Thread

Display

How do I time stamp cells to match points in a teacher's audio lecture? Student needs help

Re: How do I time stamp cells to match points in a teacher's audio lecture? Student needs

Re: How do I time stamp cells to match points in a teacher's audio lecture? Student needs

Re: How do I time stamp cells to match points in a teacher's audio lecture? Student needs

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions