PP3321
Active Member
Dear Chandoo Community,
Thank you always for sharing your knowledge and expertise...
Today I have 1 problem...
I need to track how many hours I am spending on Excel each day.
Would you suggest writing a VBA code to do this,
or should I get free app (I'm using Windows)
*Maybe I can use a code like this to simply enter date and time everytime I open workbook and close...
I would be extremely grateful if you could recommend a tool for this...
Thanking you in advance...
Thank you always for sharing your knowledge and expertise...
Today I have 1 problem...
I need to track how many hours I am spending on Excel each day.
Would you suggest writing a VBA code to do this,
or should I get free app (I'm using Windows)
*Maybe I can use a code like this to simply enter date and time everytime I open workbook and close...
Code:
Private Sub Workbook_Open()
Workbooks.Open "Time Tracker.xlsx"
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) = Date
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0) = Time
Application.DisplayAlerts = False
Workbooks("Time Tracker.xlsx").Save
Workbooks("Time Tracker.xlsx").Close
Application.DisplayAlerts = True
End Sub
I would be extremely grateful if you could recommend a tool for this...
Thanking you in advance...