Create Macro for Timestamped cells to match Notes in audio lecture using Excel
$30-250 USD
Paid on delivery
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.
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.
Thank you very much for any help you can offer.
Project ID: #4107514
About the project
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!
I have a workable solution, which I can deliver almost immediately. I am near your time zone and can start NOW. There is a conditional requirement for capturing the timestamp though. Read my PM please, BEFORE accepting More
What you want exactly? Automatically detect the beginning time of every words? Or just excel macros? I can do that for u, but still have some questions.
Hi, I have got EXACTLY what your requirement is and your macro is ready with me. I can deliver it immediately! Please see PM for details.
Hello there, as a new freelancer I would love the opportunity to work on this project, but I do have a few questions as it is somewhat unclear about HOW you want this done. I would be very happy to work this out with y More