count time

[mc]

Hello,
can excel count time? I would like to set up 3 cells. In the first cell I
will input the value 1. In the second cell I would like to start counting
time when the first cell had the value 1 input. In the 3rd cell I would like
to have the value set to 0 after some specified count such as 10 sec.
thanks, mc

 

[Myrna Larson]

You would have to do this with macros. How are your VBA programming skills?

This would require a Worksheet_Change event macro to enter the time in the 2nd cell, and an
OnTime macro that runs 10 seconds later to clear the 3rd cell.