Hacker News new | ask | show | jobs
by LouisSayers 1181 days ago
I use a Google Spreadsheet with columns (Day, Start, Finish, Description, Time, Subtotal).

Each day I adjust the Subtotal for the previous day and put in an entry for the new day.

When I start working I put in an entry into Start, Finish e.g. 3:33pm 3:33pm, and then adjust the Finish time when I stop.

I have a sheet for the month, and when a new month comes around I add up my totals for the previous month, check that the SUM(Subtotal) is the same as the SUM(time col), and then calculate average hours worked per day / week.

I then duplicate the sheet for the next month.

Have been doing this since last year and it works great.

Edit:

I made a template for anyone interested - here you go https://docs.google.com/spreadsheets/d/1XDp-sYcrsd3Ey-Fo1p5H...

1 comments

I've been doing something similar but with Excel.

Spreadsheets might be old news but they get the job done for so many things.