-
Notifications
You must be signed in to change notification settings - Fork 2
Use Cases for Overtime Calculation
Alexander Bigga edited this page Aug 11, 2023
·
1 revision
The following desribes some example use cases for the attendance and leave management with Odoo.
- 5 days a week on Monday to Friday
- 40 hours per week == 8 hours per day
- 6 weeks holiday a year ("paid time off") == 6 * 5 = 30 days
- 4 days a week on Monday to Thursday
- 20 hours per week, 5 hours per day
- 6 weeks holiday a year ("paid time off") == 6 * 4 = 24 days
German company located in Bavaria. The following public holidays apply in 2023:
- Neujahr, 2023-01-01
- Heilige Drei Könige, 2023-01-06
- Karfreitag, 2023-04-07
- Ostersonntag, 2023-04-09
- Ostermontag, 2023-04-10
- Tag der Arbeit, 2023-05-01
- Christi Himmelfahrt, 2023-05-18
- Pfingstmontag, 2023-05-29
- Fronleichnam, 2023-06-08
- Mariä Himmelfahrt, 2023-08-15
- Tag der Deutschen Einheit, 2023-10-03
- Allerheiligen, 2023-11-01
- 1. Weihnachtsfeiertag, 2023-12-25
- 2. Weihnachtsfeiertag, 2023-12-26
The employees may work every day.
Work on weekend, public holiday and on leaves should be rated as overtimes.
Work on regular working days is not limited to the configured working time. E.g. configured 9-17h == 8h, but attendances are valid too from 6-10h and 18-22h.
| check-in | check-out | working-time | theoretical-hours | overtime | note |
|---|---|---|---|---|---|
| 2023-04-03 07:10:00 | 2023-04-03 16:25:00 | 09:15:00 | 08:00:00 | 01:15:00 | |
| 2023-04-04 07:14:00 | 2023-04-04 15:35:00 | 08:21:00 | 08:00:00 | 00:21:00 | |
| 2023-04-05 | 00:00:00 | 00:00:00 | Holiday / Paid Time Off | ||
| 2023-04-06 | 00:00:00 | 00:00:00 | Holiday / Paid Time Off | ||
| 2023-04-07 | 00:00:00 | 00:00:00 | Public Holiday (Easter) | ||
| 2023-04-10 | 00:00:00 | 00:00:00 | Public Holiday (Easter) | ||
| 2023-04-11 | 08:00:00 | -08:00:00 | No attendances | ||
| 2023-04-12 | 08:00:00 | -08:00:00 | No attendances | ||
| 2023-04-13 | 08:00:00 | -08:00:00 | No attendances | ||
| 2023-04-14 | 08:00:00 | -08:00:00 | No attendances | ||
| 2023-04-17 06:31:00 | 2023-04-17 15:10:00 | 08:39:00 | 08:00:00 | 00:39:00 | |
| 2023-04-18 06:58:00 | 2023-04-18 12:30:00 | 05:32:00 | 08:00:00 | -02:28:00 | |
| 2023-04-19 06:39:00 | 2023-04-19 14:45:00 | 08:06:00 | 08:00:00 | 00:06:00 | |
| 2023-04-20 06:19:00 | 2023-04-20 14:27:00 | 08:08:00 | 08:00:00 | 00:08:00 | |
| 2023-04-21 08:10:00 | 2023-04-21 15:18:00 | 07:08:00 | 08:00:00 | -00:52:00 | |
| 2023-04-24 06:45:00 | 2023-04-24 15:22:00 | 08:37:00 | 08:00:00 | 00:37:00 | |
| 2023-04-25 07:15:00 | 2023-04-25 17:20:00 | 10:05:00 | 08:00:00 | 02:05:00 | |
| 2023-04-26 06:50:00 | 2023-04-26 14:30:00 | 07:40:00 | 08:00:00 | -00:20:00 | |
| 2023-04-27 07:42:00 | 2023-04-27 17:00:00 | 09:18:00 | 08:00:00 | 01:18:00 | |
| 2023-04-28 08:33:00 | 2023-04-28 12:45:00 | 04:12:00 | 08:00:00 | -03:48:00 | |
| 2023-04-30 09:30:00 | 2023-04-30 14:45:00 | 05:15:00 | 00:00:00 | 05:15:00 | Weekend |