How to Create a Weekly 24 Hour Calendar With Excel

Make your own 24-hour weekly calendar using Excel's columns and rows or customize an Excel calendar template.

Make Your Own

Step

Open a blank spreadsheet in Microsoft Excel and type Time in the A1 box.

Type Time in A1.
credit: Image Courtesy of Microsoft
Type Sunday in B1 and drag box to H1.
credit: Image Courtesy of Microsoft

Step

To create the days of the week labels, type Sunday in the B1 box and drag the box to H1, covering seven columns. The other days of the week automatically fill in these boxes.

Type the start time in A2 and drag box to A25.
credit: Image Courtesy of Microsoft

Step

Type the time you want the daily calendar to start in the A2 box and drag the box to the A25 box. This automatically adds the rest of the hours for the day.

Fill in agenda.
credit: Image Courtesy of Microsoft

Step

Type your schedule and appointments in the corresponding boxes.

Use a Scheduling Template From Microsoft Office

Step

Open a new Excel document and search for a weekly calendar template.

Search for a weekly calendar template.
credit: Image Courtesy of Microsoft
Select the template and click Create.
credit: Image Courtesy of Microsoft

Step

Select the template you want to use and click Create.

Fill in your schedule.
credit: Image Courtesy of Microsoft

Step

The templates in Excel are interactive. To fill in a Microsoft template, click the field you want to fill in and type your information.

Find a Template Online

Step

Go to the Microsoft Office website and search for templates.

Search for a template on the Office website.
credit: Image Courtesy of Microsoft
Select the template you want to use.
credit: Image Courtesy of Microsoft

Step

Search for the template you want to use and click the template's thumbnail picture.

Click Open in Excel Online.
credit: Image Courtesy of Microsoft

Step

Click Open in Excel to open the template in an Excel document.

Sign in if you have an account or create one.
credit: Image Courtesy of Microsoft

Step

Sign in with your Microsoft account if you have one. You can also sign in with your work or school account. If you do not have an account, create a new account.

Click Continue.
credit: Image Courtesy of Microsoft

Step

Click Continue to create your template document.

Fill in the schedule or click Open in Excel.
credit: Image Courtesy of Microsoft

Step

If you want to continue to use Excel Online, click the field you want to fill in and type your agenda. However, if you want to work in your Excel desktop application, click Open in Excel.

Fill in your schedule.
credit: Image Courtesy of Microsoft

Step

After you open your Excel desktop application, you can click the field you want to change and fill in your schedule.