Skip to content

Comment on Ask HN: How do you track your work hours?

Comments

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...

I've been doing something similar but with Excel.

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

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.