Hi guys,

I was wondering if there any any good ways to keep track of how much time I am actually in a specific workbook, doing work.

In my head, I came up with two ways of doing so.

1) On a Workbook Activate event, start a timer. When the workbook is deactivated, stop the timer.

However, a problem a rises if you have multiple workbooks and one serves as a reference, thus diluting the Timer time compared to the actual time spent on a specific project. Another problem I am unsure about is when you switch to a non-excel program, does that deactivate the workbook?

2) The second idea I had was to have VBA keep a log every minute of what workbook is active. Again, you will run into similar problems.

Does anyone have any thoughts/ comments/ suggestions before I go to the effort of making such macros?

Thanks!
Brad