Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

While working in Microsoft Excel sometimes we need to make an hourly schedule so that we can calculate and maintain a schedule for our daily or weekly activities. Users always find an hourly schedule helpful created in excel. Today in this article, I am sharing with you how to make an hourly schedule in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Quick Steps to Make an Hourly Schedule in Excel

In the following, I have described 4 quick and simple steps to make an hourly schedule in excel. Stay tuned!


Step 1: Create the Dataset with Proper Information

  • First, let’s start with creating the dataset. To do that, simply 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

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

Make an Hourly Schedule to Make an Hourly Schedule in Excel

  • Thereafter, pull the fill handle row-wise to fill with the leading time with a gap of 1 hour.

Make an Hourly Schedule to Make an Hourly Schedule in Excel

  • In summary, we will get the hours in cells (F6:T5).

  • To finish with, we have filled with color on the cells (F6:T6). Thus our final table will look exactly like the following.

Make an Hourly Schedule to Make an Hourly Schedule in Excel


Step 3: Fill with Data to Calculate Total Hour

  • In general, we will 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.

Fill with Data to Calculate Total Hour to Make an hourly Schedule in excel

  • Now at the end of the day, we collected how much time “Ashley” worked and in which hours.
  • Therefore, we found a total of “10 Hours” he put the effort into the workstation.

  • In the same fashion, collecting data we have got the result representing employees’ efforts on an hourly schedule.

Fill with Data to Calculate Total Hour to Make an hourly Schedule in excel

Read More: How to Create a Monthly Schedule in Excel (3 Simple Ways)


Step 4: Add Comments to the Table

  • In this final step, we will add notes to specific cells so that we can mark them easily. For that, select a cell (D6) and press the “New Note” from the “Review” option.

Add Comments to the Table to make an hourly schedule in excel

  • Just type your note in the cell so that you can work more smoothly.

  • In conclusion, we have successfully made an hourly schedule in excel within a short moment. Simple isn’t it?

Make an Hourly Schedule in Excel

Read More: Create Depreciation Schedule in Excel (8 Suitable Methods)


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.

Conclusion

In this article, I have tried to cover all the steps to make an hourly schedule in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo