Spec me a excel timer

[mangobreeder]

Hi

what i need is a excel worksheet which has 2 buttons, start and stop and a timer

i need the time to be saved when i exit and then carry on when i go back in.

it is so i can time how long i spend on particular projects.

 

[Meeko]

I should be able to help you here...

Just to confirm though - are you looking to calculate the time you are actually in a specific workbook or the time between one workbook and another?

Let me know as I have code for either which I can go and dig out for you. (neither code relies on you pressing buttons to start/stop the timer as this is done automatically using the workbook_open and workbook_beforeclose events)

 

[mangobreeder]

i will be working out of different Apps, Visio, emails. project, etc,

just need a timer to see how longi spend on the project