Time Blocking Template: Hourly Schedule for Google Sheets & Excel

A time blocking template turns your to-do list into a schedule by giving each hour of the day a job before the day begins. Each weekly page of our weekly planner spreadsheet has an hourly schedule for every day, and each block gets a type you name yourself (deep work, meetings, family, exercise), right beside that day’s main task and priorities. It suits people whose days mix fixed commitments with flexible work: office workers, freelancers, students and parents.

What the Time Block Planner Tracks

• Hourly schedule. One column per day on the weekly page. You give each hour a type from the list on the setup tab, so a glance down the week shows where the time goes.
• Schedule types. Named once on the setup tab. Five or six is plenty: for example Deep work, Meetings, Admin, Exercise, Family and Personal.
• Main task and priorities. One main task for each day, a short list of priorities with checkboxes, and the contacts you need to call, text or email.
• Tasks and dates. Tasks with a priority for each day, weekly tasks that can happen on any day, and the due dates that fall in the week.
• Calendar tab. Gathers every main task and task from all six weeks, filters them by done status and priority, and prints for your desk.

The planner covers six consecutive weeks from the start date you choose, one tab per week.

Example: A Time-Blocked Work Week

Here is a weekday schedule for a freelance designer who does the school pickup at 3 pm. The first row is each day’s main task; the rows below are the hourly blocks, filled in with the planner’s block types.

Time	Mon	Tue	Wed	Thu	Fri
Main task	Send three logo concepts	Draft website copy	Finish homepage mockup	Revise mockup after client call	Send invoices, review the week
7 am	Family	Family	Family	Family	Family
8 am	Exercise	Admin	Exercise	Admin	Exercise
9 am	Deep work	Deep work	Deep work	Deep work	Deep work
10 am	Deep work	Deep work	Deep work	Deep work	Deep work
11 am	Meetings	Deep work	Meetings	Meetings	Admin
12 pm	Personal	Personal	Personal	Personal	Personal
1 pm	Admin	Meetings	Deep work	Deep work	Admin
2 pm	Deep work	Deep work	Admin	Meetings	Admin
3 pm	Family	Family	Family	Family	Family
4 pm	Admin	Deep work	Admin	Deep work	Personal
5 pm	Family	Family	Family	Family	Family
6 pm	Family	Exercise	Family	Exercise	Family
7 pm	Personal	Personal	Personal	Personal	Personal
8 pm	Personal	Personal	Personal	Personal	Personal

Counting the 70 weekday blocks by type gives this week’s shape:

Block type	Hours	Share of the 70 blocks
Family	18	26%
Deep work	17	24%
Personal	16	23%
Admin	9	13%
Exercise	5	7%
Meetings	5	7%

What the numbers show:

• Work takes 31 hours (deep work, meetings and admin), and deep work is 17 of them, or 55%. Meetings are held to 5 hours by keeping them out of the 9 am to 11 am window.
• The main task lands in deep work. Tuesday’s copywriting gets 5 deep work hours because writing needs long stretches. Friday has only 2, so Friday’s main task is admin. On Thursday the main task depends on the 11 am client call, so its deep work block comes after it, at 1 pm.
• Fixed blocks went in first. The 3 pm pickup and the 5 pm family dinner sit in the same place every day, and exercise fits around them: three mornings and two evenings.

Saturday and Sunday stay mostly Family and Personal, with one Admin block on Sunday evening to plan the next week.

How to Set Up the Time Blocking Template

1. Open the Excel file, or make your own copy in Google Sheets from the link in your download.
2. On the setup tab, enter your start date and name your schedule types. Short, distinct names read best down a column.
3. Add birthdays and holidays on the setup tab too, so they show on the calendar tab before you block that week.
4. On the week’s tab, block the fixed things first: meetings, classes, pickups and meals.
5. Choose each day’s main task and put it in your best focus hour. Add two or three priorities and tick them as you finish.
6. Fill the remaining hours with types: deep work in two-hour chunks where you can, small jobs batched into one or two admin blocks, and at least one open block a day.
7. Add the week’s tasks with a priority, and the due dates. At the end of the week, filter the calendar tab to tasks not done and decide what moves to next week.
8. Print the calendar tab if you like a paper view. When the six weeks are up, set a new start date or start a fresh copy.

The Method Behind Time Blocking

Time blocking works because it forces a trade: an hour given to one thing is not available for another. That turns “I’ll get to it” into a visible choice.

Four habits keep a blocked week realistic. Put fixed commitments in first, since everything else has to fit around them. Give the main task your best hour, usually before meetings start. Batch small jobs (email, invoices, calls from the contacts list) into admin blocks instead of letting them leak into deep work. And leave one open block a day for whatever runs over.

Our time blocking examples guide shows four sample days (an office worker, a parent at home, a student and a freelancer) with rules that keep blocks honest. Students can start with the weekly planner for students, which blocks classes, study time and assignment due dates. To choose the main task and priorities themselves, read how to prioritize your day, and for the Sunday session where the blocks get planned, see how to plan your week.

Blocks also give habits and chores a home. A 10-minute walk kept in a named slot is easier to tick in the habit tracker, and a Sunday cooking block makes the meal planner with grocery list easier to follow through the week.

Build Your Own Time Blocking Template in Google Sheets or Excel

Minimum layout

• A2:A15: the times, one row per hour
• B1:H1: Monday to Sunday
• B2:H15: the blocks
• J2:J7: your list of block types
• K2:K7: hours per type

Times down the side

Type 7:00 in A2, then put =A2+TIME(1,0,0) in A3 and fill down to A15. That works in both apps. In Google Sheets or Excel for Microsoft 365 you can instead enter =SEQUENCE(14,1,TIME(7,0,0),TIME(1,0,0)) in A2 and format the column as time.

A dropdown of block types

• Google Sheets: select B2:H15, open Data > Data validation, add a rule, choose “Dropdown (from a range)” and enter J2:J7.
• Excel: select B2:H15, open Data > Data Validation, set Allow to List and Source to =$J$2:$J$7.

Color each type

Select B2:H15 and add one rule per type with the formula =B2=$J$2 for the first type, =B2=$J$3 for the second, and so on.

• Google Sheets: Format > Conditional formatting, then “Custom formula is”.
• Excel: with B2 as the active cell, Home > Conditional Formatting > New Rule > “Use a formula to determine which cells to format”.

Because each rule points at the list rather than the words, renaming a type keeps its color.

Hours per type

In K2, =COUNTIF($B$2:$H$15,J2), filled down to K7. Each cell is one hour, so the count is the hours. In L2, =K2/COUNTA($B$2:$H$15) gives each type’s share of the blocks you filled in, formatted as a percentage. Both formulas are identical in Google Sheets and Excel. On the weekday example above, Deep work returns 17 hours and 24%.

For half-hour blocks, step the times by TIME(0,30,0), use 28 rows and divide each count by 2.

Who This Hourly Schedule Template Suits

It suits you if:

• Your days mix fixed meetings, classes or pickups with work you schedule yourself.
• You want the day’s main task, priorities and hourly plan in one view.
• You want every hour of the week labeled, so you can see where the time went.

It suits you less if:

• You plan in 15-minute slices. The schedule is hourly.
• You need an alert before each block. The planner has no reminders, so keep alarms for hard start times on your phone.
• You share a schedule with a team. This is a personal planner, not a booking calendar.

One last tip: at the end of each day, give anything unfinished a named block tomorrow instead of leaving it on the list, so it has a time and not just a place on the page.