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

Closed Posted Jan 8, 2013 Paid on delivery
Closed 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.

Excel

Project ID: #4107514

About the project

13 proposals Remote project Active Feb 14, 2013

13 freelancers are bidding on average $54 for this job

deepbluetech

I am an Excel macro expert and can take on the job. Let me know.

$60 USD in 1 day
(52 Reviews)
4.8
pierreho

Hi Gnobles. See my file which does what you want. Kind regards

$80 USD in 1 day
(24 Reviews)
4.8
Gooroo

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!

$30 USD in 0 days
(10 Reviews)
3.7
FLinCanada

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

$45 USD in 0 days
(7 Reviews)
2.5
hbxfnzwpf

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.

$150 USD in 10 days
(1 Review)
2.2
paintthesky14

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.

$40 USD in 1 day
(2 Reviews)
2.0
charliehart

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

$100 USD in 7 days
(0 Reviews)
0.0
NineGold

I have written this type of macro before; I can do it in less than one day. Pls see PM.

$30 USD in 1 day
(0 Reviews)
0.0
Adrianexcel

Attached is a sample. I currently create time stamp file. I am intrested in this job.

$30 USD in 1 day
(0 Reviews)
0.0
emunne

Hello, I can do what you need in 1 hour, hire me and you will not regret it.

$30 USD in 1 day
(0 Reviews)
0.0
ntpmsc

Hi, No Words, But action. Pay me only if your are OK with the output Thanks

$30 USD in 1 day
(0 Reviews)
0.0