A weekly hourly planner is a grid with times down the left and the seven days across the top, so every hour or half hour of your week gets its own cell. In Excel, you can control the whole grid from three cells (start time, end time and slot length) and let formulas total how many hours you’ve planned for each kind of work.
This guide shows how to set up the planner, with tested formulas for the time slots, hour totals and a highlight for the current slot. It also covers a one-day version, print settings that fit a week on one page, and what changes in Google Sheets.
What a weekly hourly planner template includes
| Part | Cells | What it does |
|---|---|---|
| Settings | B1:B4 | Start time, end time, slot length in minutes, and the Monday the week starts on |
| Day headers | B5:H5 | Monday to Sunday, with dates |
| Time column | A6 down | Each slot’s start time, built from the settings |
| Planning grid | B6:H65 | One cell per time slot per day |
| Category totals | J6:K10 | Hours planned for each type of activity |
Keeping the settings on the same sheet as the grid matters if you’ll ever use Google Sheets, for a reason the Google Sheets section explains.
Download the weekly hourly planner template with adjustable time slots, category totals and print settings ready. Set your hours, then start blocking out next week.
Weekly or daily: which hourly planner to use
| Planner | Works best for | Trade-off |
|---|---|---|
| Weekly hourly planner | Seeing fixed commitments and free time across the week; time blocking | Less room in each cell for task details |
| Daily hourly schedule | Busy days with many short tasks, priorities and notes | No view of the rest of the week |
Use the weekly planner to place your big blocks, then a daily schedule on the days that need more detail. Both are covered below.
How to build a weekly hourly planner in Excel
Step 1: Enter the settings
| Cell | Label in column A | Example value |
|---|---|---|
| B1 | Start time | 7:00 AM |
| B2 | End time | 6:00 PM |
| B3 | Slot length (minutes) | 30 |
| B4 | Week starting | 10/26/2026 |
Type times with a colon and AM or PM, such as 7:00 AM, so Excel stores them as times rather than text. A quick check: times and dates line up on the right of the cell by default, while text lines up on the left.
For B4, type the Monday of the week you’re planning. To find this week’s Monday, =TODAY()-WEEKDAY(TODAY(),3) returns it. Copy that result and paste it as a value, though, or the date will move to next week while your plan stays put.
Step 2: Add the day headers
In B5, enter =B4. In C5, enter =B5+1 and copy it right to H5. Select B5:H5, press Ctrl+1 and use the custom format ddd m/d so each header reads like Mon 10/26.
Step 3: Build the time slots
In A6, enter =$B$1. In A7, enter this formula and copy it down to A65:
=IF(A6="","",IF(ROUND((A6+$B$3/1440)*1440,0)>=ROUND($B$2*1440,0),"",A6+$B$3/1440))Excel stores a time as a fraction of a day, and a day has 1,440 minutes, so adding $B$3/1440 adds one slot. The formula stops once the next slot would reach the end time. ROUND converts both times to whole minutes before comparing them, which stops tiny rounding errors in Excel’s time math from adding or dropping a row.
Format A6:A65 as h:mm AM/PM. With the example settings you get 22 slots, from 7:00 AM to 5:30 PM. Change B3 to 60 and the grid switches to hourly slots; change it to 15 and you get quarter hours. Sixty rows cover 7 AM to 10 PM in 15-minute slots, so copy the formula further down if your day is longer.
If you’d rather skip the formula, type 7:00 AM in A6 and 7:30 AM in A7, select both and drag the fill handle down. Excel continues the pattern, though you’ll need to redo it to change the slot length.
Step 4: Set up categories and drop-downs
List your activity types in J6:J10, for example Deep work, Client calls, Admin, Exercise and Personal. Then select the grid B6:H65, go to Data > Data Validation, choose List and set the source to =$J$6:$J$10.
By default, data validation rejects anything that isn’t on the list. On the Error Alert tab, clear “Show error alert after invalid data is entered”. You keep the drop-down for quick picks but can also type details, such as “Deep work: client logo”. Starting each entry with its category keeps the totals in the next step accurate.
Step 5: Total the hours for each category
In K6, then copy down to K10:
=COUNTIF($B$6:$H$65,J6&"*")*$B$3/60The asterisk is a wildcard, so the formula counts every cell that starts with the category name, including “Deep work: client logo”. Multiplying the count by the slot length and dividing by 60 turns slots into hours.
Two more totals are useful:
| Total | Formula | What it shows |
|---|---|---|
| Planned hours | =COUNTA($B$6:$H$65)*$B$3/60 | Hours with anything in them |
| Available hours | =COUNT($A$6:$A$65)*7*$B$3/60 | All the hours in the grid this week |
COUNT only counts numbers, so the empty strings at the bottom of the time column are ignored.
Step 6: Add color and a current-slot highlight
For category colors, select B6:H65 and choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. Enter a category name and pick a fill. Repeat for each category.
For the rest, use Home > Conditional Formatting > New Rule > Use a formula, with the range B6:H65:
| Rule | Formula | Suggested format |
|---|---|---|
| Current time slot | =AND(B$5=TODAY(),$A6<>"",MOD(NOW(),1)>=$A6,MOD(NOW(),1)<$A6+$B$3/1440) | Thick border |
| Today’s column | =B$5=TODAY() | Light fill |
| Weekend | =WEEKDAY(B$5,2)>5 | Grey fill |
NOW returns the date and time together, and MOD(NOW(),1) keeps only the time. The highlight moves when the workbook recalculates, which happens whenever you edit a cell; press F9 to refresh it otherwise.
For a long block, type the label once and drag the fill handle down rather than merging cells. A merged cell keeps its text in the top cell only, so COUNTIF would count a three-hour block as half an hour.
Daily hourly schedule (hourly day planner)
A daily version uses the same time column with more room for each task:
| Column | Heading | Example |
|---|---|---|
| A | Time | 9:00 AM |
| B | Task | Draft proposal for Lane & Co |
| C | Category | Deep work |
| D | Priority | High |
| E | Done | x |
Build column A with the Step 3 formula, and add drop-downs for Category and Priority with data validation. This formula shows how much of the day’s list is done:
=IFERROR(COUNTIF(E6:E65,"x")/COUNTA(B6:B65),0)COUNTA counts the tasks you’ve entered, so three tasks with two marked done shows 67%.
Example: a freelancer’s time-blocked week
Here’s a week planned with the example settings (7:00 AM to 6:00 PM, 30-minute slots), Monday to Friday:
| Category | When | Slots | Hours |
|---|---|---|---|
| Deep work | 9:00 AM to 12:00 PM, every weekday | 30 | 15 |
| Personal (lunch) | 12:00 to 1:00 PM, every weekday | 10 | 5 |
| Client calls | 2:00 to 4:00 PM, Tuesday and Thursday | 8 | 4 |
| Admin | 4:00 to 5:00 PM, Monday, Wednesday and Friday | 6 | 3 |
| Exercise | 7:00 to 8:00 AM, Monday, Wednesday and Friday | 6 | 3 |
That’s 30 planned hours out of 55 weekday hours in the grid, leaving 25 open for project work, email, travel and the things that always come up. Leaving that much open is deliberate. A week planned to the last slot falls apart at the first overrunning call.
The totals also show trade-offs at a glance. If a new client wants three more hours of calls, you can see they’ll come out of deep work or the open hours, not out of thin air.
A student can use the same layout: classes go in first as fixed blocks, then study blocks for each course, so the totals show whether study time matches each course’s workload.
How to time-block your week
- Enter fixed commitments first: classes, standing meetings, school runs.
- Put focused work in the hours when you concentrate best, and protect them.
- Group small tasks, like email and invoices, into one or two admin blocks instead of scattering them.
- Leave open slots every day for overruns and surprises.
- On Friday, compare what you planned with what happened and adjust next week’s blocks.
For step 5, copy the week’s sheet (right-click the tab, choose Move or Copy, tick Create a copy) and name the copy Actual. Record what you really did there, then compare the two sets of category totals side by side.
Printing a weekly calendar with time slots
- Select A5:H27 (or down to your last time slot) and choose Page Layout > Print Area > Set Print Area.
- Choose Page Layout > Orientation > Landscape.
- In the Scale to Fit group, set Width and Height to 1 page.
- Turn on Page Layout > Sheet Options > Gridlines > Print, or add borders, so the slots show on paper.
- Preview with File > Print.
If the text comes out too small with 30-minute slots over a long day, switch B3 to 60 or print the morning and afternoon on separate pages. When a grid runs over more than one page, Page Layout > Print Titles > Rows to repeat at top set to $5:$5 repeats the day headers on each page.
For a blank printable weekly calendar with time slots, clear B6:H65 and print. The times and dates stay.
Using the hourly planner in Google Sheets
The formulas in this guide (time math, ROUND, WEEKDAY, COUNTIF with wildcards, COUNT, COUNTA, MOD and NOW) work in Google Sheets. A few differences:
- Conditional formatting rules in Google Sheets can’t refer to other sheets directly. That’s why the settings sit on the same sheet as the grid.
- For drop-downs that still accept typed text, open Data > Data validation, choose “Dropdown (from a range)” and, under Advanced options, set invalid data to show a warning instead of rejecting it.
- NOW updates when the sheet changes. Under File > Settings > Calculation, you can also set it to update every minute, which keeps the current-slot highlight moving.
Common mistakes to avoid
- Typing times as text. “9am” may not be recognized as a time; “9:00 AM” is. Times that sit on the left of the cell are usually text.
- Merging cells for long blocks. Merged cells break the hour totals, as Step 6 explains.
- Filling every slot. Plans with no open time stop working by Tuesday.
- Changing the slot length after filling in the week. The times move but your entries don’t, so a 9:00 block can end up next to 8:00. Pick the slot length before you plan.
- Forgetting travel and setup time around meetings and classes.
Ways to improve the planner
Reuse your week: copy last week’s sheet, change B4 to the new Monday and keep the recurring blocks. Clear only what changes.
Chart your time: select J5:K10 and choose Insert > Insert Pie or Doughnut Chart. A doughnut of hours by category makes an unbalanced week obvious.
Add a notes row: a row under the grid for each day’s top three priorities keeps the big picture visible without crowding the slots.
Frequently asked questions
How do I make an hourly schedule in Excel?
Put the days across the top and the times down the left, then fill in the grid. A formula based on a start time, end time and slot length builds the times for you, and COUNTIF can total the hours for each activity. The steps above show each formula.
How do I create 30-minute time slots in Excel?
Type 7:00 AM in one cell and 7:30 AM in the cell below, select both and drag the fill handle down. For slots you can change later, use the Step 3 formula with 30 in the slot length cell.
How do I print a weekly calendar with time slots on one page?
Set a print area around the grid, switch to landscape and set Scale to Fit to 1 page wide and 1 page tall. If the text is too small, use hourly slots or split the day across two pages.
How do I calculate the hours spent on each activity?
Count the cells for each activity and multiply by the slot length in hours: =COUNTIF($B$6:$H$65,J6&"*")*$B$3/60. With 30-minute slots, ten Admin cells equal five hours.
What is time blocking?
Time blocking means giving each part of your day a set job, such as focused work from 9 to 12 or email from 4 to 5, instead of working from an open to-do list. A weekly hourly planner is a natural place to do it, because you can see every block and the gaps between them.
Should I use a daily or a weekly hourly planner?
Use a weekly planner to see your commitments and free time across the week. Add a daily schedule for days with many short tasks that need priorities and tick boxes.
Getting started
Set the start and end times to match your real day, not an ideal one, and enter only the fixed commitments for next week. The gaps left over are the time you actually have for everything else.
The template includes both the weekly grid and a daily schedule tab.