Case Time Resolution

[Aman Semwal]

Dear All,

Help me to create a macro.

We have a team of 20 members, each having different workbook for their production. Sharing the sample workbook of mine to understand what i need. We get some case# to work as our daily target.

What I need :

I want to create a macro where I want 2 buttons to be created for Start and stop.

What it will do :

The first button will start the time for the first case# and the second button will stop the time. The time for which it counted should be on Column D for the case number and so on for all case.

It should create a measurement time for all the case.

 

[vletm]

Aman Semwal
... or Sample without any 'buttons' ...

Note: Follow instructions​

 

[Aman Semwal]

but when i click the left arrow key when my cursor is on any end cell it gets removed ...

Secondly it should capture the time at first instance as i can see it captures whenever i go to the cell.

 

[Belleke]

maybe something like this?

 

[vletm]

Aman Semwal
1) Did You open that file?
2) Did You select eg cell C2 (It would show current time)
3) Did You select after that eg D2 (It would show current time and Used time)
... if You select again C2, then that case will start from zero!
You didn't want to 'continue'-option!

You can 'Start' any number of cases and
You can 'End' any number of 'started' cases as You need.

Your Secondly ...
hmm? What would You mean?

 

[Aman Semwal]

it should capture the time only once not again..

 

[Aman Semwal]

maybe something like this?

I liked this but i need some changes like once any case copied and time gets generated it should not generate again if i copy the case and want to generate

 

[Belleke]

Like this?
See attached

 

[Aman Semwal]

its generating time for the same case but how much time i add on text button

 

[vletm]

Aman Semwal - it should capture the time only once not again..
Then You should be patient and
select those 'Start' & 'End'-cells only once!