How to Create a Basic Excel Shift Rota
Are paper timesheets giving you a headache? If so, then why not create your own basic excel shift schedule template?
This is probably the most simple excel shift rota to build. As such, it lacks a lot of sophisticated functionality and requires manual data entry. If you want to make things really easy, we suggest using RotaCloud – their software integrates perfectly with People™’s HR system, and building shift rotas is a piece of cake.
For now though, here is the basic way to create an excel shift schedule template (that also works for most spreadsheet programs):
- You will need 22 columns in total.
- Label the first column ‘Name’.
- Label the next three columns: Monday IN. Monday OUT. Monday HOURS.
- Repeat step 3 for each day of the week.
From here, you can simply use this as your template and manually enter the data yourself. To add a bit of automation, however, you can use a FORMULA to ask the HOURS cell to calculate the total hours worked for each person on each day. To do this, you’ll need to:
- Select the HOURS cell.
- Type the following: =SUM(
- Click the IN cell
- Type the following: –
- Click the OUT cell
- Type the following: )
The end result will probably look something like this: =SUM(A2-A3)
You can apply this formula for each person in the NAME column, and for each day of the week.
What Happens Next?
Providing you have done everything right, you should be able to simply add each employee’s name to the NAME column, then add their start and finish time for each day of the week – the hours for each day will automatically pop up.
Of course, we highly recommend avoiding spreadsheets altogether and trying an automated HR solution, such as People™’s HR system or RotaCloud’s shift software… Watch this 4-minute video to discover more ways to make HR easier
Stay ahead with HR
Get free HR insights, expert tips and exclusive interviews, and start making more impact at work
HR Software Optimised for Beaches or Sofas
What would you do with the unrestricted freedom to work from anywhere? Would you stay in the office, work from your sofa or kick back and work from the comfort of sandy paradise? This 1min video is all about HR software optimised for beaches and sofas. Enjoy!
Will Your HR Software Survive the Mobile Revolution
Why HR Super Heroes Need ‘Responsive Design’
Embark on your most ambitious HR journey to date
This short video takes you through the different ways people helps you work smarter, challenge your abilities and get yourself noticed – all using one simple, stunning cloud-based platform.
What is the Bradford Factor?
Ever wondered how the Bradford Factor formula calculates your employees' absence scores? Check out this graphic to have the Bradford Factor calculation explained to you clearly.
So… Who Exactly ARE You?!
If you like the sound of People, but you’re not familiar with the name… then it’s only natural that you’ll have questions.
6 Reasons People’s HR System Delivers Something Different
So many HR systems claim to be different. But when you actually look at what they offer, it’s easy to see that they’re all selling the same old thing...
See People HR in action
View our short video demo
Get started absolutely free
No credit card required