Hi,

I have this problem that I need some help.

Lets say that I have to shake apple trees daily.
Everyday I have an undetermined number of trees to deal with, it could
be 10, it could be 20.
Each tree also takes an undetermined amount of time to shake.
It could take 5-10-15-etc minutes to shake.
Once it is done comes cleanup time, and it can take any random amount
of time before I am ready to move to the next tree,

I only have a button that adds to the daily total and it is usually
done at the end of working on the tree.

I want to get as accurate as possible the amount of time that I am in
"off time" ie not shaking a tree.
The easiest way would be to add another button that would start/stop a
timer, but of course there would be no challenge in it. :)

With the click of one button (the add button that is used to count the
number of trees) is there a way to somehow extrapolate how long I am
not shaking a tree?
The reason is because of the extra clicks necessary, I might forget to
stop the button for ie, and well I am just lazy to click buttons. :)

What sugestions would you have about this?

Correct me if I'm wrong, but I gather you want to click a button when you
start shaking the tree, and click it again when you stop; then (when you've
finished picking up the apples under that tree) click the button when you
move on to the next tree and start shaking it, and click it again when you
stop shaking and start cleaning up that tree, and so on. Right?

It's not a hard one, I think. But isn't it a programming question? I think
you want to repost this question in the Excel Programming forum, rather than
the general one.

--- " wrote:
Lets say that I have to shake apple trees daily. Every day I have an
undetermined number of trees to deal with; it could be 10, it could be 20.

Each tree also takes an undetermined amount of time to shake. It could
take 5-10-15-etc minutes to shake.

Once it is done comes cleanup time, and it can take any random amount
of time before I am ready to move to the next tree.

I only have a single button that adds to the daily total and it is usually
done at the end of working on the tree.

I want to get as accurate as possible the amount of time that I am in
"off time" ie not shaking a tree. The easiest way would be to add another
button that would start/stop a timer, but of course there would be no
challenge in it. :) With the click of one button (the add button that is used
to count the number of trees) is there a way to somehow extrapolate how
long I am not shaking a tree?

Hi,

No, the button is clicked once when I am done shaking the tree to add
to the total.
No other clicks.
You are probably right that VBA will be required but right now I am
just trying to figure out how to figure out this.


On Feb 19, 1:32*am, Bob Bridges
wrote:
Correct me if I'm wrong, but I gather you want to click a button when you
start shaking the tree, and click it again when you stop; then (when you've
finished picking up the apples under that tree) click the button when you
move on to the next tree and start shaking it, and click it again when you
stop shaking and start cleaning up that tree, and so on. *Right?

It's not a hard one, I think. *But isn't it a programming question? *I think
you want to repost this question in the Excel Programming forum, rather than
the general one.