Lux Aeterna
Board Regular
- Joined
- Aug 27, 2015
- Messages
- 191
- Office Version
- 2019
- Platform
- Windows
I've made an excel sheet that automatically adds working hours (arrival - departure) and overtime hours for every month.
What I'd like to do is to add overtime up to 20 hours per month in total.
In the picture below there are 22 working days, so I'd like to have a maximum of 20 days of 1 hour overtime, not 22 as it is now (yellow box).
Moreover, there are months that someone might work, for example, for 15 days. So a possible solution would be 10 days of 1 hour overtime and 5 days of 2 hours overtime.
Finally, someone might have worked for 8 days. In that case I'd like to have 2 hours overtime daily.
Max overtime per day is 2 hours, and max overtime per month is 20 hours.
Hope it's not too complicated, thank toy in advance.
PS: Wherever you see 15:00, it's the sum of the cell on the left (14:00) plus 1:00. I can add the excel file if necessary
What I'd like to do is to add overtime up to 20 hours per month in total.
In the picture below there are 22 working days, so I'd like to have a maximum of 20 days of 1 hour overtime, not 22 as it is now (yellow box).
Moreover, there are months that someone might work, for example, for 15 days. So a possible solution would be 10 days of 1 hour overtime and 5 days of 2 hours overtime.
Finally, someone might have worked for 8 days. In that case I'd like to have 2 hours overtime daily.
Max overtime per day is 2 hours, and max overtime per month is 20 hours.
Hope it's not too complicated, thank toy in advance.
PS: Wherever you see 15:00, it's the sum of the cell on the left (14:00) plus 1:00. I can add the excel file if necessary