Time Based Counter Buttom

[abcjert10]

I'm trying to track total units completed hour by hour. What I want to be able to do is have a single button that adds to the number of units complete based on what time it is. So, if it is between 3pm-4pm then pushing the button will add one to cell that is designated Hour 3-4, and so on so forth.

I would like there just to be the one button to simplify things for the operator entering the data.

Is this possible? Has anyone done anything like this?

Any help would be greatly appreciated!

 

[ranman256]

it seems better to post the timestamp:
TIME, QTY
2/13/2018 8:00:02 AM, 1
2/13/2018 8:00:02 AM, 1

then run a pivot table to sum every record by the hour.

sub btnGo_click()
activecell.value = now
activecell.offset(0,1).value = 1
activecell.offset(1,0).select
end sub