Create Macro for Timestamped cells to match Notes in audio lecture using Excel

  • Status Closed
  • Budget N/A
  • Total Bids 13

Project Description

My understanding is that I can hire someone here to help me build a macro to do the following. Please let me know what would be reasonable for providing me with a worksheet to do the following:

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 recorder starts at 00:00 minutes and seconds. I want the notes I take in Excel cells to correspond with key points that my teacher makes on the audio recording.


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.

Thank you very much for any help you can offer.

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online