Hourly Schedule Template in 15/30 Minute Intervals

• Version
• 20'148 Downloads
• 45 KB File Size
• January 4, 2022 Updated
• 0 Number of comments
• ★★★★★

  ★★★★★
  Rating

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.

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.

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.

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."

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."

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

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.

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.

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.

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.

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:

Customize

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.

Here is a how-to example:

We hope this article was helpful!

Please send us feedback about your user experience.