How do I track time in Google Sheets?

Help |

Collections: Chrome Extension.

Written by Melissa Spillett

Last modified on

October 14th 2024

Effective time tracking plays a crucial role in proficient project and task management. Integrating this functionality seamlessly into Google Sheets can significantly boost your productivity. Utilizing a Chrome time tracking extension lets you effortlessly integrate time tracking into Google Sheets. 

This article covers:

• Installing Jibble’s Chrome Extension
• Linking Google Sheets and Jibble
• Tracking time in Google Sheets

---

Installing Jibble’s Chrome Extension

1. You can install the Jibble extension through one of the following options:
   1. Using the Jibble Web App:
      • Log into your Jibble account and locate the Get the app button on your dashboard.
      • When prompted, select Chrome Extension to be redirected to the Chrome Web Store.
   2. Directly from the Chrome Web Store:
      • Visit the Chrome Web Store and search for the Jibble Time Tracker extension.
2. Click Add to Chrome to install the extension.
3. After installation, an icon will appear in your browser’s toolbar.
4. To access the extension, click on the puzzle piece icon in the top right corner of your Chrome toolbar.
5. Pin the Jibble Time Tracker by clicking the pin icon next to it, ensuring quick access while using Google Sheets.

---

Linking Google Sheets and Jibble

Tip 💡: If you’ve previously activated the Google Docs integration within Jibble’s Chrome time tracking extension, Google Sheets will be automatically included as well.

1. Log in to your Google account.
2. Open up Google Sheets.
3. Click the Jibble icon in the Chrome toolbar to open the timer extension.
4. Log in to your Jibble account or create a new account if you don’t have one.
5. Click on the three horizontal lines in the top right corner.
6. Go to Integrations.
7. Ensure the checkbox for Google Docs is enabled.

---

Tracking time in Google Sheets

Jibble’s Time Tracker provides multiple effective methods for directly tracking time within Google Sheets.

• Using the embedded Jibble timer 

1. Navigate to the spreadsheet you wish to track time for within Google Sheets.
2. Within the spreadsheet view, you will see the Jibble in button.
3. Click on the Jibble in button to start tracking time.
4. Select an activity and project if required.
5. Notes will be prefilled based on the titles of your spreadsheets in Google Sheets.
6. Click on Save to start the timer.
7. Once clocked in, the timer button will be automatically updated to “Jibble out”.
8. To stop the timer, click on the Jibble out button and tap on Save.

---

• Using keyboard shortcuts

1. Click on the Jibble icon in your Chrome toolbar.
2. Tap on the three horizontal lines in the top right corner and click on Settings.
3. Enable Keyboard Shortcuts.
4. Once enabled, use the shortcut command Ctrl+Shift+s on Windows or Command+Shift+S on Mac to clock in. 
5. To clock out, use the same keyboard commands.

Note: The previously used activity and project (if any) will be tagged when clocking in via keyboard shortcuts. There will be no notes to be added.

---

• Using right clicks

1. Right click on your mouse and select Jibble | Clock in.Note: The previously used activity and project (if any) will be tagged when clocking in via right click. There will be no notes to be added.
2. To clock out, right click again select Jibble | Clock out.

---

• Using text highlighting

1. Highlight any text in your Google spreadsheet, right click and select Jibble.
2. The clock in screen will be displayed with your notes automatically included.
3. Select an activity and project if required and tap Save.