Excel timestamp w/ button to specific cells

[bjaeger2003]

Hi,

I am trying to gather metrics about time spent running database queries. I thought I would have an excel spreadsheet that had a start and stop button that will log the time so I can say 1)this many queries were run by me in this many days and 2)it took this much time.

I've come up floating button labeled Start. I'd like to assign this to specific cells, but this will work until I can figure it out. I'd like to able to assign it with a macro that put the start time in a specific cell. I'm not sure if it is possible have it continue down a column automatically. As in, hit the button and C1 logs the time. push again and C2 logs the time etc. I apologize for the complete lack of knowledge. Thank you in advance for any help!

Macro so far:

Please Login or Register  to view this content.

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

As per forum rules, could you please EDIT your post above and add CODE and /CODE tags around your posted code? Thanks.

[bjaeger2003]

Thank you so much! That did it!