Hourly Schedule Template in 15/30 Minute Intervals

  • Version
  • 18'330 Downloads
  • 45 KB File Size
  • January 4, 2022 Updated
  • 0 Number of comments
  • Rating
table of content

How often do you say, "I just can't get anything done today"? In today's increasingly fast-paced world, our attention is pulled in hundreds of different directions. It's a wonder we get anything done at all. But there is hope! We found that keeping a daily schedule is an essential part of achieving our most important goals.

To help us stay organized and focused, we created a series of schedules. We turned some of our favorites into templates, and posted them below. With options ranging from 5 - 7 days, and in 15 - 30 minute intervals, we hope you'll find one that works to help you meet your own goals!

Template Contents

Below are the worksheets included in this template.

30 Min - 5 Days
24-hour schedule calendar at 30-minute intervals over a 5-day period.

30 Min - 6 Days
24-hour schedule calendar at 30-minute intervals over a 6-day period.

30 Min - 7 Days
24-hour schedule calendar at 30-minute intervals over a 7-day period.

15 Min - 5 Days
24-hour schedule calendar at 15-minute intervals over a 5-day period. Ideal for the uber-busy.

15 Min - 6 Days
24-hour schedule calendar at 15-minute intervals over a 6-day period. Ideal for the uber-busy.

15 Min - 7 Days
24-hour schedule calendar at 15-minute intervals over a 7-day period. Ideal for the uber-busy.

Using the Template

Personalize and Print

When you find one you like – put your name on it! The first row has the impersonal title, "24 Hour Schedule." To better customize it, just click inside that first row, and you'll be able to change the title to something more fitting.

schedule change title

If you prefer to write your schedule by hand, the old-fashioned way, just hit print – our worksheets are already set up to fit on one page for easy printing.

General Use

Our schedule template has a cell that allows you to enter the 1st day of the week. If you decide to start your 1st day of scheduling on a Wednesday (instead of Monday), you can do so. Once the 1st day is entered, the next 4, 5, and 6 days will automatically appear as dates across the top of the template.

schedule enter week beginning

If you want to take a few days off but don't need to see the gaps in your planner, you can simply overwrite the date with your next scheduled workday in the appropriate cell across the top. The rest of the days to the right will increase by 1, starting with your return date.

schedule overwrite the date

Cross Off Completed Tasks

In Excel, you can cross off completed tasks to keep track throughout the day. To cross off a completed or canceled task, right-click on the cell containing the task, select "Format Cell" from the pop up list, and check the "strikethrough" box under "Effects."

schedule cross off tasks

Historical Records and New Schedules

Ever need to be reminded of what happened yesterday? Or two weeks ago? Now, you won't have to worry about it. Just save each week's schedule in a file. You can either create a completely new worksheet, or add a new page to an existing worksheet, to start the next weekly schedule.

Each method is explained below.

Option 1: Create a new worksheet for each new schedule.

Right-click on your preferred worksheet schedule and select "Move or Copy," check the box for "Create a copy," and click "OK."

schedule new worksheet

Finally, click on the new worksheet and rename it as you'd like.

schedule rename new worksheet

Note: The benefit of creating new worksheets is that you won't have to scroll down or across many weeks of previous schedules.

Option 2: Add a new page in an existing worksheet for each new schedule.

If, for example, you'd like to organize your scheduling data by month, it makes sense to add a new page in an existing worksheet (and label that worksheet with the current month).

To do this, first make sure you are in "Page-Layout" view.

page layout view

Highlight the schedule table and copy it by hitting the 'Control' and 'V' buttons (Ctrl+V). Next, scroll down or across and paste the schedule table on the new page. Finally, update the date in the first column to reflect a new weekly schedule.

schedule paste the table

Note: This template is set up to repeat the top row and first column. This has some benefits, but can make it awkward to paste data into a new page. To disable repeating rows and columns go to the "Page Layout" menu, select "Page Setup." Then, select the "Sheet" tab and delete any data for rows and columns to repeat at top or left.

schedule disable repeating rows

Freeze Panes

If you are managing your schedule in Excel, it can be a bit cumbersome to have the first row with dates disappear as you scroll down to a later time in the day. To avoid this, you can freeze the first row so that it remains on your screen no matter how far down you scroll.

schedule freeze panes

Note: To freeze panes you must be in either "Normal" or "Page Break" view, not "Page Layout" view.

Next, click into the cell below the top row with dates, and go to the "View" menu. Select "Freeze Panes" and select the 1st Freeze Panes option.

Here is a how-to example:


Change Color Scheme

You can further personalize your template by decorating it! If you'd like to add some color, simply highlight all relevant cells and use the "Fill Color" tool to change the background color. To change text color, repeat these steps and use the "Font Color" tool.

schedule change color scheme

Here is a how-to example:

We hope this article was helpful!

Please send us feedback about your user experience.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 10

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Rotating Schedule

52 KB / 58995 downloads
Time Schedule Template

23 KB / 2293 downloads
Weekly Class Schedule

317 KB / 51097 downloads
Cleaning Schedule Template

22 KB / 3460 downloads
TV Schedule

325 KB / 4542 downloads
College Schedule Template

26 KB / 3570 downloads
Construction Schedule Template

51 KB / 4884 downloads
Employee Schedule Maker

5 Mb / 63597 downloads
Event Schedule Excel Template

16 KB / 4228 downloads
View Comments
There are currently no comments.