How to stamp live time and run a timer after triggered by an event?

[pkaspa]

Please help! I'm not an expert using Excel or with VBA, but I would really like to know how I can perform this operation in Excel. If there is an addin or program I could get, then please point me in the right direction. If you know how I could do it, I would be very grateful for the help.

Here's what I need to do:

I have already set up a real time monitor (in cell m3) that updates from the system time whenever a change is made anywhere on the sheet (or by running a macro to automate the updates). The clock is in hour, minute, and second format. I want to be able to track the exact minutes and seconds from that clock.

Basically, I need to find out how I can start a timer to track the time elapsed after an event occurs. Here's the path I would like the operation to follow:

1. Cell (h12) value reads "GO"

2. That "GO" event triggers a record or log of the exact time on the real-time clock (in cell m3) to be made and displayed in a cell (p2).

3. Another cell (p3) will keep a continuous update of the elapsed time since the log of the exact time the event occured (p2).

4. Final cell (p14) will indicate whether the elapsed time (p3) is greater than or equal to a specified time length (b9) by reading "YES".

I know this may be somewhat complicated, but I need to implement this operation for my research. Any help in the right direction will be greatly appreciated. Thanks so much. -Paul