How to Make an Hourly Schedule in Excel (with Easy Steps)

Watch Video – Make an Hourly Schedule in Excel

Step 1: Create the Dataset with Proper Information

Make a heading, and below that type “Date” to store the date in the cell.

Create the Dataset with Proper Information to Make an Hourly Schedule in Excel

As we are creating an hourly schedule for a workstation thus we need “No”, “ID”, “Employee Name”, and “Total Working Hour” to complete the dataset.

Step 2: Insert Time in Total Working Hour Column

We will make borders for some columns to store the time hour-wise.
The workstation’s starting time is “8:00 AM,” so we put “8:00” in the cell (F6).
Change the rotation of the text by selecting Rotate Text Up from the Home ribbon.

Pull the Fill Handle row-wise to fill with the leading time with a gap of 1 hour.

We will get the hours in cells (F6:T5).

Fill with color on the cells (F6:T6). Our final table will look exactly like the following.

Step 3: Fill with Data to Calculate Total Hour

Fill the cells with data to calculate the total hour. Let’s begin.
Collecting data from the workstation we got the “Employee Name”, and “ID” for the employees appointed to the floor.

We collected how much time “Ashley” worked and in which hours.
We found a “10 Hours” in which he put effort into the workstation.

We collected data, which represented employees’ efforts on an hourly schedule.

Step 4: Add Comments to the Table

We will add notes to specific cells to mark them easily. Select a cell (D6) and press the New Note from the Review option.

Enter your note in the cell so that you can work more smoothly.

We have successfully made an hourly schedule in Excel within a short moment.

Things to Remember

If you want you can also attach comments for specific cells where multiple users can reply with their opinion. To do so go to the Review option and click the New Comment to add comments.