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.
13 freelancers are bidding on average $54 for this job
Hi sir! *I FINISHED it!* ... see PM please. I've tried and managed to do EXACTLY what you described ... btw highly experienced in Excel programing among other stuff. Pick me PLEASE so I can gain some points here!