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 created in Excel. Today in this article, I am sharing with you how to make an hourly schedule in Excel.
Watch Video – Make an Hourly Schedule in Excel
How to Make an Hourly Schedule in Excel: 4 Quick Steps
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.
- 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.
- Thereafter, pull the Fill Handle row-wise to fill with the leading time with a gap of 1 hour.
- 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.
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.
- 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.
Read More: How to Create a Monthly Schedule in Excel
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.
- 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?
Read More: How to Create a Weekly Schedule in Excel
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.
Download this practice workbook to exercise while you are reading this article.
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. Stay tuned and keep learning.