Utilize OT/Done Columns in Clocking Schedules
Introduction
You will find the attendance data of users especially work time, over time, short etc will change if you do different configurations in clocking schedule. This might be due to the OT/ Done columns in the clocking schedule.
Benefit
This feature allow you to set whether to calculate overtime automatically without setting a time into schedule OR calculate overtime by fixed time assign in clocking schedule.
Procedure
Example 1
Clocking schedule without OT/Done Settings in clocking schedule:
Clocking time of user
Number of clocking
|
1st
|
2nd
|
3rd
|
4th
|
5th
|
6th
|
Cloking time
|
09:00
|
12:39
|
13:15
|
16:15
|
19:05
|
23:40
|
Result in Attendance Sheet
There is no preset time available in the OT/ Done column in this clocking schedule. When employee clocks out after the preset out time, 6:00pm, Ingress/TCMS V3 will calculate and show result in his OT column. The logic and calculations of Ingress/TCMS V3 are based on the clock out time of the employee.
If Actual Out time of user > Preset out time
--> OT = Actual Out time – Preset Out time
Actual Out time of user = 11:40pm or 23:40
Preset Out time of user = 6:00pm or 18:00
Preset Out time of user = 6:00pm or 18:00
Therefore OT = 23:40 – 18:00
= 5 hours 40 min
Ingress/TCMS V3 will do calculation on total working time. Please take note that work time does not include OT of employees.
If Actual Out time of user > Preset Out time
--> Work time = Preset out time – actual in time
Where work time = 18:00 – 09:00
= 9 hours
If Actual Out time of user < Preset Out time
--> Work time = Actual Out time – Actual In time
Example 2
Clocking Schedule with OT/ Done Setting in clocking schedule
Clocking time of user
Number of clocking
|
1st
|
2nd
|
3rd
|
4th
|
5th
|
6th
|
Cloking time
|
09:00
|
12:39
|
13:15
|
16:15
|
19:05
|
23:40
|
Result
Ingress & TCMS V3 will capture the 2 extra clocking times if user configured OT and DONE times in the clocking schedule.
OT is defined as 19:00 in clocking schedule. This means that employee can perform OT work, but the OT will only start at 7:00pm. DONE is defined as 23:00 in clocking schedule. This allows employee to work and claim for OT. Anyway, working time after DONE, 23:00 will not be considered as OT.
OT
|
DONE
|
Difference
| |
Preset
|
19:00
|
23:00
|
4 hours
|
Actual
|
19:05
|
23:40
|
4 hours 35 min
|
Calculated by Ingress/
TCMS |
19:05
|
23:40
|
3 hours 55 min
|
As preset in clocking schedule, the difference between 19:00 and 23:00 is 4 hours.
The formula is
OT = Preset Done time – Preset OT time
OT = 23:00 – 19:00
OT = Preset Done time – Preset OT time
OT = 23:00 – 19:00
= 4 hours.
Now TCMS will not allow the OT of user more than 4 hours, as preset.
If user OT time is earlier than preset OT time, Ingress/TCMS V3 will use preset OT time.
Example 18:55; TCMS will capture and show 18:55 in Attendance Sheet. TCMS will use preset time, 19:00 for calculation of OT.
Example 18:55; TCMS will capture and show 18:55 in Attendance Sheet. TCMS will use preset time, 19:00 for calculation of OT.
If user OT time is later than preset OT time, Ingress/TCMS V3 will use the actual OT time.
Example 19:05, TCMS will capture and show 19:05 in Attendance Sheet. TCMS will now using this 19:05 for calculation of OT.
Example 19:05, TCMS will capture and show 19:05 in Attendance Sheet. TCMS will now using this 19:05 for calculation of OT.
If user Done time is earlier than preset Done time, Ingress/TCMS V3 will use the Actual Done time.
Example 22:50, TCMS will capture and show 22:50 in Attendance Sheet. TCMS will now using this 22:50 for calculation of OT.
If user Done time is later than preset Done time, Ingress/TCMS V3 will use the preset Done time.
Example 23:40, TCMS will capture and show 23:40 in Attendance Sheet. TCMS will now using preset Done time, 23:00 for calculation of OT.
In this example, user OT time is 19:05, which is later than preset OT time; TCMS will use 19:05 for calculation. User DONE time is 23:40, which is later than preset DONE time, TCMS will use preset DONE time, 23:00 for calculation.
OT = Preset Done time – actual OT time
--> OT = 23:00 – 19:05
= 3 hours 55 min (<4hours)
The calculation of work time is same in Example 1, Clocking schedule with- out OT/Done.
Example 3
Clocking Schedule with OT/ Done Column as Scheduled Work Settings in Clocking Schedule
Clocking time of user
Number of clocking
|
1st
|
2nd
|
3rd
|
4th
|
5th
|
6th
|
Cloking time
|
09:00
|
12:39
|
13:15
|
16:15
|
19:05
|
23:40
|
Result
The calculation of Ingress/TCMS of work time and OT will change, if the option “Work time recorded into OT and Done column considered as” is set to Work.
Now the OT and Done column will become scheduled work columns as IN and OUT do. User will have 2 break times in a working day. First break will be from 12:30 to 13:30, and second break will be from 18:00 to 19:00.
Now the Work time is calculated as below,
Work time = Done time – In time
Work time = Done time – In time
If Actual Done time of user > Preset Done time
Work time = Preset Done time – actual in time
Where work time = 18:00 – 09:00
Work time = Preset Done time – actual in time
Where work time = 18:00 – 09:00
= 9 hours
If Actual Done time of user < Preset Done time
Work time = Actual Done time – Actual In time
Work time = Actual Done time – Actual In time
In this example, Done time is 23:40 (> preset Done time), therefore
Work time = Preset Done time – Actual In time
Work time = Preset Done time – Actual In time
= 23:00 – 14:00
= 14 hours
Since the Done time is more than preset Done time, Ingress/TCMS will calculate the OT of user.
OT = Actual Done time – Preset Done time
OT = 23:40 – 23:40
OT = 23:40 – 23:40
= 40 min
Ingress/TCMS V3 will also calculate the Short time of user. Short time will only calculate if user comes in later than preset In time and preset OT time. Late from lunch will not consider as short time. The calculation is as follow,
Total short time = short time (IN) + short time (OT)
Short time (IN) = Actual In time – Preset In time
= 09:00 – 09:00
= 0 min
Short time (IN) = Actual In time – Preset In time
= 09:00 – 09:00
= 0 min
Short time (OT) = Actual OT time – Preset OT time
= 19:05 – 19:00
= 5min
Therefore total short time = 0 min + 5 min
= 5min
I have a problem. The OT column shows worktime included. worktime coloumn has no data. What seems to be the issue?
ReplyDeleteI have a problem. The OT column shows worktime included. worktime coloumn has no data. What seems to be the issue?
ReplyDeleteHello Sir,
DeleteGood day. Based on your issue, kindly send your backup database to us at support@fingertec.com for further checking. Please also advice us a specific user ID and date to narrow down the scope for checking.
My company has set 3 flexi schedule which are
ReplyDelete1. 9am to 6 pm
2. 10pm to 7pm
3. 11pm to 8pm
Employees can choose at what time they want to clock in everyday. How i want to set the schedule which the device can automatically detect the working hours, and additional hours (more than 8 hours) as an overtime?
Dear Sir / Ma'am,
DeleteGood day to you,
Referring to your inquiry, you may configure an Open Schedule which the system will automatically assign the respective shift schedule for each worker based on the 1st clock-in of the day.
However, each shift MUST NOT contain an overlapping time between each other to avoid redundancy on the clocking schedule.
Kindly refer to the link below for more details
http://www.fingertectips.com/2016/05/creating-open-schedule-for-shift-roster.html
Regarding your second inquiry, when you've set the IN and OUT time in the daily type schedule, the system will automatically count the overtime straightaway after the OUT time. For example, if you've set the OUT time as 6 pm, the system will count 6.01 PM as an overtime of 1 minute (refer here http://prntscr.com/pfsyg1 & http://prntscr.com/pfsykx)
Thanks & Best Regards
Hi, some of my company staff will go out to give customer service during working hour.
ReplyDeleteFor example: in 9am ,out for service 10am, back from service 12pm, out for lunch 12.30, back from lunch 1.30pm and goin back at 6pm.. May I know how to set my clocking schedule, so that the attendance sheet can show all the 6 in out record. Thanks
Dear Sir,
DeleteGood day to you,
For the staff who do not have any specific IN - OUT timing , you may assign them under Flexi schedule. If you want to monitor all the IN - OUT transaction logs, you may opt for Flexi with the job costing by following the link given below
https://www.fingertectips.com/2015/11/ingress-tcms-v3-software-reports-for.html