Clock or counter function in excel?

**KiBBo** · 11-09-2007, 02:05 PM

Hi,

Is there a counter or clock function in excel?
I want to count time in a cell when another cell gets a certain value...is that possible?

Your help is much appretiaced, thanks!

,KiBBo

**Excelenator** · 11-09-2007, 02:14 PM

put this code into the Worksheets VBE object. Change A1 witht he cell that you want to verify and the offset should reference the cell that you want the time input to. Also, change the IF condition of Target = 5 to whatever condition you are checking for.

Please Login or Register  to view this content.

**KiBBo** · 11-12-2007, 03:34 PM

Thanks for you reply Excelenator!

I think I explained myself badly...I really need a "timer" or calculator which counts seconds when I trigger it with certain value in certain cell. With "Now" function the value (actual time) is always refreshed and I don't now anymore when count started....any other suggestions or advices how I can use that "Now"- function?

**mikerickson** · 11-12-2007, 03:47 PM

In the code module for the sheet:

Please Login or Register  to view this content.

In a normal module:

Please Login or Register  to view this content.

put =timeInterval() in a cell and it will start counting as soon as the contents of A1 are 2 or greater. That cell will refresh its value whenever you change the selection. Setting A1 to 0 will reinitialize the timer.

The cell location and trigger values to match your needs would go in the Worksheet_Change routine.

Edit: Change in routine to prevent crashing when text is in A1.

**Reafidy** · 11-12-2007, 05:12 PM

You can use ontime.

Place this code in a module:

Please Login or Register  to view this content.

Put this under the sheet module:

Please Login or Register  to view this content.

And this in the thisworkbook module:

Please Login or Register  to view this content.

When ever the value in cell a1 gets above 1 the timer will start in B1. It will only stop and reset when the cell goes below 1.

You could also use a start/stop button if you like.

Format cell B1 as custom format "hh:mm:ss"

See attached for further help.