Using offset function to move the result one row down

Hi all,

I have a sheet where a user presses a number of buttons and have a macro in place that counts the amount of times the button was pushed. Now I would like to add a column that records the time at which each click occured.

Eg Using column J to display the data;

Starting from cell J6 which will display the first time at which the button was pushed

Every time the button is pressed i would like the time it was clicked displayed on row below the cell that displays the previous time it was pushed

Ie 1st push J6 = 9:00am
2nd push J7 = 10:13am
3rd push J8 = 3:40pm

and so on

I beleive this is possible with a looping of an offset function, but wasnt exactly sure of how to fine tune it.

If anyone could assist that would be great

Cheers

Thanks, its works perfectly. Cheers