Weekly Schedule Template (Hourly, Excel)
Last updated June 2026
Half-hour blocks from 6:00 AM to 10:00 PM, seven day columns, one printable grid: the Schedule sheet maps an entire week at a glance. The header row and time column stay frozen while you scroll, so afternoon rows keep their labels. A free single-sheet .xlsx built for students, shift workers, and anyone who time-blocks their week.
Weekly Schedule Template (Hourly, Excel)
weekly-schedule.xlsx · free · no signup
Works in Excel, LibreOffice Calc, and Google Sheets (File → Import).
SHA-256: 81385e798e4815adc639460336a07464074320cc6e018fbb232625b03b5ad779
| A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|
| Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
| 6:00 AM | Run | Run | Run | ||||
| 6:30 AM | |||||||
| 7:00 AM | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | ||
| 7:30 AM | Commute | Commute | Commute | Commute | Commute | ||
| 8:00 AM | Standup | Deep work | Standup | Deep work | Standup | Errands | Rest |
What's inside
Sheets
ScheduleThe full week on one page: a 30-minute time column from 6:00 AM to 10:00 PM and seven day columns, Monday through Sunday, with a bordered grid and alternating row shading.
Columns
- TimeColumn A — half-hour slots from 6:00 AM down to 10:00 PM (33 rows), formatted
h:mm AM/PM. Frozen so it stays on screen. - Monday–FridayColumns B through F — one column per weekday. Type the activity into the cell next to its start time.
- Saturday–SundayColumns G and H — the weekend, kept in the same grid so the whole week fits on a single printed page.
Formulas that do the work
The time column is pre-filled, but if you rebuild it this adds 30 minutes to the slot above. Copy it down column A and every row steps forward half an hour.
Optional add-on: put a real date in B1 and this returns its weekday name (Monday, Tuesday…) so the header tracks an actual week instead of fixed labels.
Optional add-on: drop this below a day column to count how many half-hour slots you have booked, a quick read on how full a day is.
How to use it
Pick the day and time slot
Find the row for your start time in column A, then move across to the day column. Click the cell where the row and day meet and type the activity.
Block longer events across rows
For a two-hour meeting, type the name in the start-time cell and leave the rows below it blank — the borders make the block read as one event. Or merge the cells to lock the span.
Scroll without losing your place
Panes are frozen at
B2via View → Freeze Panes → Freeze Panes, so the day header and the time column stay pinned while you scroll into the afternoon and evening slots.Adjust the hours to your day
If your day starts earlier, edit the first time in
A2and recopy=A2+TIME(0,30,0)down the column. Delete trailing rows you don't need.Print the whole week on one page
The grid is sized to fit a single landscape sheet. Use File → Print (
Ctrl+P), set orientation to Landscape, and confirm the preview shows all seven days. See how to print on one page if a column spills over.
Compatibility
- Microsoft Excel. Excel for Microsoft 365, Excel 2016 and later (Windows and Mac).
- LibreOffice Calc. Opens directly — formulas, validation lists, and formatting carry over.
- Google Sheets. Upload via File → Import → Upload, or drag the file into Drive and open with Sheets.
The frozen header row, the time format, and the bordered grid all survive a Google Sheets import. After importing, re-check View → Freeze if the panes don't carry over.
Frequently asked questions
- What time range does this weekly schedule cover?
- The time column runs from 6:00 AM to 10:00 PM in 30-minute increments — 33 rows in total. To extend it, edit the first or last time cell and copy the half-hour step formula down column A.
- Can I change the start day from Monday to Sunday?
- Yes. The day labels in row 1 (
B1throughH1) are plain text, so just retype them in any order you like. Reorder Saturday and Sunday to the left if you prefer a Sunday-first week. - How do I block out a multi-hour event?
- Type the event in its start-time cell, then either leave the rows beneath it empty or select the span and merge the cells so it reads as one block. See how to merge cells without losing data.
- Why do the header and time column stay visible when I scroll?
- Freeze panes are set at
B2, which pins row 1 and column A in place. To change or clear them, select a cell and use View → Freeze Panes — see how to freeze rows and columns for the steps. - Does this hourly planner work in Google Sheets?
- Yes. Upload the .xlsx through File → Import → Upload; the half-hour grid, the time format, and the day headers come across cleanly. Re-apply the frozen panes from View → Freeze if Sheets drops them during import.