4 ms·
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 en
by LouisSayers 4y 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-Fo1p5HG6324cbxTxBXChq0E_DECEM/edit?usp=sharing https://docs.google.com/spreadsheets/d/1XDp-sYcrsd3Ey-Fo1p5H...
- foobarbaz33 4y agoI've been doing something similar but with Excel. Spreadsheets might be old news but they get the job done for so many things.