Stopwatch with Lap Function in Excel

[jclusman]

I am completely new to this, but I'm looking for some help in inserting a stopwatch into an Excel document. The document is used for tracking entrances/exits in a theatrical production.

Here's what I'd like to do:
I'd like to be able to start a stopwatch that starts at 0:00:00 and keeps a running time. But then I'd also like to be able to click a button to capture the time of an entrance/exit (like a lap feature) and have it auto fill a predetermined cell...and doing this 25-30 times before wanting to stop the running time. Each time the "lap feature" is captured it would auto fill the next cell in a column.

Any insight would be greatly appreciated.

 

[ranman256]

I would post data vertically...each lap creates a new lap in the next ROW.
I would say a START button, to write start time, now(), and lap = 0
and a LAP button that posts the time (in col A) and lap time in Col B. then advances 1 row.