Macro for Time Tracker

[Rishendra Rathore]

Hi!

Just want a help in assigning Macro in Excel for tracking time. I want to assign Macro in an Image, let say in a Clock image. So, if I click on that clock image, time get started in any cell (which is selected) & by again clicking on the clock image beside that particular cell, time get stop. And the difference of time should be caputured (that can be done by subtraction formula). Hope my question is clear. Please help!

[AranDG]

Something along these lines should do the trick I think:

Please Login or Register  to view this content.

Code assumes you have an identifier cell (B1) to see whether the time has stopped or started and your results for start and stop times appear in cells B2 & B3

[Rishendra Rathore]

Thanks, I assign the macro on the image, however when I click on the image after placing the cursor on cell, it's throughing an error "cannot run the macro. the macro may not be available in this workbook or all macros may be disabled". And I saved the excel as Macro enabled workbook. Is there something which I am missing here??

[AranDG]

Can you attach the workbook for review please?

[Rishendra Rathore]

Hi, Please find attached. Many thanks!!