Calculate overtime with Excel - so it'll work

You can easily calculate your overtime with the Excel spreadsheet. We'll tell you exactly how this works in this practical tip.

Calculate overtime with Excel - how it works

1. Download and open this template for Excel.
2. Enter the month in which you would like to make the calculation.
3. In the field below, enter the hours you have to work per day.
4. You can now enter the start and end of your work for the respective days.
5. Breaks can also be entered there. You have to enter "08:00" for 8 hours.
6. On the right side you will see both overtime and minus hours.
7. At the bottom of the table you can see your total working hours and the total overtime or minus hours at the end of the month.

In the next practical tip, we'll tell you how to convert the date into a calendar week in Excel.