If you have ever worked part time you probably had to plan when you want to come to work. Maybe today and tomorrow 8 hours and some other day you wanted to leave earlier to do something at home. But how to keep on track if there are enough working hours already?
To solve this issue myself I've written this little script that allows you to create an event in dedicated Google Calendar (so you can hide it to not mess with other stuff) every time you work and then after only a couple of clicks make from these events a Google Spreadsheet with a summary of everyday work and how many hours it is in a whole month. If you define your monthly goal it will show you how many hours are left to be planned or how much time you've exceeded your plan.
- Go to Google Calendar settings (gear icon)
- Add new calendar
- Click on your new calendar and choose Integrate calendar. Here's your calendar ID - keep it somewhere
- Open new Google Spreadsheet and create sheet named like "XI 2018" for November 2018 or "III 2019" for March 2019 (you can create many sheets for different months)
- Then open Script editor and paste the script from this repository
- Adjust the first line of code with your own calendar ID and amount of hours you want to work this month
- Save project with any name you like
- Import macro to the spreadsheet
- Choose generateTimeReport
- Choose Tools > Macros > generateTimeReport
- When asked for permissions, give access to everything listed
- If you add some events to this calendar they will be shown in the summary in this sheet. That's all