Kick off the new school year with lessons from our Back to School 2022 collection to help students express themselves, build relationships, and stay organized.
Playback Speed:
Transcript

Your schedule probably changes from day to day.

You might work 3 days a week and have a training class 2 days a week.

In this extension, you will use the formulas and cells you’ve already created to make a template for tracking how you spend your time.

To start, duplicate your time-tracking sheet.

This will make an exact copy so that you keep all of the same formulas and formatting.

Give your copied sheet a name to set it apart.

To create a blank time-tracker, delete the activities, hours, and minutes from the cells you already filled out, but keep the “Totals”.

This creates a blank template for you to track your time in the future, but it will keep all of your formulas, so you don’t have to set them all up again.

Then, use keyboard shortcuts like Control-C or Command-C to copy your formatted cells, so that you can use them for multiple days.

Don’t worry about deleting the total hours and minutes left.

The formulas you entered will stay in the cells, so that they’ll keep adding, dividing, and multiplying the way you told them to.

Skip a row following your totals and use the Control-V or Command-V keys to paste your formatted cells.

Then, add in a new date to track your time.

Now that you’ve set up a template, you can repeat your time management process quickly.

Use your template to calculate the time you need or want to spend on tasks on any day.

Choose an Extension
Create a Time-Tracking Template

Copy, paste, and delete cells to create a blank time tracking template.

Activities Drop-Down List

Use data validation to create a list of activities you can use for tracking.

Conditional Formatting for Time

Use conditional formatting to change the color of a particular activity if it takes too much time or not enough.

Instructions

Learn more about managing your time in Google Sheets with these extensions.