Khurramshaikh47
Member
- Local time
- Today, 11:09
- Joined
- Aug 19, 2021
- Messages
- 212
Hi,
I have an attendance table. There are some fields:
1) Time_In
2) Time_Out
3) Overtime
The field overtime calculates the overtime hours after completing 9 working hours.
I need to restrict the overtime hours value:
In the screenshot below the Overtime column is the column that is currently in use while Overtime New column is my desired column.
Thank you in advance.
I have an attendance table. There are some fields:
1) Time_In
2) Time_Out
3) Overtime
The field overtime calculates the overtime hours after completing 9 working hours.
I need to restrict the overtime hours value:
- If the Overtime hour is less than 1.00 then convert it to 0.00.
- After the first 1 hour convert the overtime to round down to 0.50.
- 0.00 and negative values will remain the same.
In the screenshot below the Overtime column is the column that is currently in use while Overtime New column is my desired column.
Thank you in advance.