Hello.

New to the forum. Good with excel but do am diving into new territory with macros and VBA.

I would like to create a stop watch. I've been researching this topic on forum and the internet for days but am getting nowhere.

Using Excel 2011 on a Mac, Lion 10.7.

I'm tracking scene lengths in movies. For instance think of your favorite movie- the first scene is usually so many minutes long... scene two is so many minutes long and so on. I want to track these lengths scene by scene and elapsed.

Example

A1 would start and always be 00:00:00 (hh:mm:ss) It's the start of the movie.
B1 would be the end of scene 1. Let's say 3 minutes or 00:03:00.
C1 Would be the duration of the scene, in this case 00:03:00
A2 would then be 00:03:00 and the start of scene 2
B2 would be the end of scene 2, let's say 2 minutes 30 seconds
C2 would then be 00:02:30
A3 would in turn be 00:05:31 as it's following the elapsed time.

And so on...

I've been entering this information manually which is fine but takes a while.

Recently I discovered a few excel "stopwatches" people have created where you can double click in a cell and excel starts and or stops a stop watch. Very slick. I was hoping to incorporate something similar. Instead of typing time in manually, as I watch the movie when I double click the cell, excel monitors the elapsed time and fills in the respective cell accordingly.

Does that make sense?

As a final note while Excel is tracking time for me I need to be able to enter information into other cells such as notes and macros.

If anyone can steer me the right direction or get me started I would really appreciate this.

I hope the above made sense. Thanks in advance.

-D