The objective is to have our own time tracker for our tasks totality free using Google Sheets and Apps Script, to do it we will use a little script with Google Apps Script that will help us to execute this functionality. The functionality is basic but it could help us to build something more powerful if we like coding, at the end of the post you can find the link to the google sheet to clone the sheet.

These are the columns that our excel sheet will have on Google Sheet

• Status (On hold, Start, Pause, Continue, Finished)
• Task (Title)
• Start date
• Closed date
• Tracked Time (hours : minutes)