TIMER in Excel

Hello,

Please explain with VBA code, how to create a TIMER in excel.I have been goggling for this and didn't able to understand any of given results.

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

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.



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.
Thanks in advance.

Try this. Multiple stop watches.