This should suffice all your requirements associated with a roster. You can add more customizations, such as adding the totals. You can see that on a line drawn between 14 and 15 rows of the sheet. Please note that for better visualization and to be able to differentiate two employees, we have used the thick border as a separator.
Ideally, you can create this one for as many employees as you feel or have in your organization. Step 7: You can add 5 more rows for another employee and repeat step 5 as well as Step 6 to create a roster for one more employee. It should look like the screenshot below. The formatting of the cell depends upon the nature of the data present. For cell C9, use color baby pink, and for cell C10, let it be white and copy and use the same alternate cell formatting in excel Cell Formatting In Excel Formatting cells is an important technique to master because it makes any data presentable, crisp, and in the user's preferred format. Step 6: Now, apply colors to alternate cells to make this look like a table. It should look like the one as shown in the screenshot below. Step 5: In column C across C9 to C14, add the titles per row as First Half Start, Lunch Break, First Half End, Second Half Start, Tea Break, Second Half End.
After adding the title, we will choose the next 5 cells varying from B9: J14 for filling the roster details of an employee. I have used the red font for dates and black for the days as well as Employee Name. Please note that the format is custom, and you can use it at your convenience. Employee Name would be the first one, and after that, each column from D to J contains one date and one day from the week starting from Monday. You can roughly say column headers for this roster. Step 4: From cells B7: J8, we are about to add some details for the shift roster therefore, create a box with Outside Border for the same range as we did in the previous step. Step 3: Create a box with Outside Borders (can be achieved with Ctrl+Shfit+& button) across cells B3: J5 and add some additional details there such as Minimum Shift Hours, Maximum Shift Hours, Overtime Hours, Overtime Rate, Night Shift Hours, Shift Allowance to capture the respective details. I have applied a red color font for the date values. You can customize the colors for this as per your requirements. Step 2: In cell A2, type “Week Start Date” and in the cell next to it (B2) type “.” This is the format in which the date will reflect for the start of the week. Step 1: In cell B1, input “Roster” as a title for the sheet and customize the formats for the same.
MAKE ROASTER FILE IN CRICKET 7 FREE
There are thousands of these templates, and you can choose any one of your choices.įollow the steps below to create a free employee roster template of your own in excel from scratch.
MAKE ROASTER FILE IN CRICKET 7 DOWNLOAD
Please note that you needed to be connected to a stable internet connection to be able to download the templates since we are downloading them as resources provided by Microsoft Office.