Working Hours Calculation with Overnight-Flexi Schedule in Ingress & TCMS V3
Introduction
In Ingress & TCMS V3, there is a Flexi clocking schedule that supports flexible working shift. It also can be used to keep records of users, who work more than a shift within a day.
Benefit
There might be some users whom are confused on how working hours is calculated for a flexi schedule and needs a better idea on how it works. So this tip is to provide some explanation with an example of a working scenario and calculations for the working and break time.
Procedure
For example, a worker comes to work at 8:00am and leaves at 11:30am. He comes in again and continue to work at 1:00pm through 8:00pm and then he rest until night. During the night he starts to work from 9:00pm till 11:00pm. His working time will be shown as below:
Working Shift
|
In time
|
Out time
|
1st working shift
|
0800
|
1130
|
2nd working shift
|
1300
|
2000
|
3rd working shift
|
2100
|
2300
|
In this example, the default settings of a new flexi schedule is used:
a) General settings: Maximum number of in-out clocking pairs for this flexi-hour schedule = 3
b) Break settings: Ignore break time = Untick (so Break time will be excluded from working hours)
Additional Settings:
c) General settings: Maximum work hours to be considered as the same day work = 20 hours
Therefore, Ingress & TCMS V3 will record the his working time as:
IN
|
BREAK
|
RESUME
|
OUT
|
OT IN
|
OT OUT
| |
TIME
|
0800
|
1130
|
1300
|
2000
|
2100
|
2300
|
Scenario
Please note that for Ingress & TCMS V3, you don't have to set a time for each shift (IN / OUT) in the clocking schedule .This is because system will follow all clocking time derived from terminal. In Overtime tab, for option “Overtime if total flexi work hour exceeds work hour of”, set this as 8 hours which means after 8 hours, system will calculate remaining time as overtime.
For example, these are the time recorded for a user:
IN time = 0900
OUT time = 1230
IN time = 1330
OUT time 1745
IN time = 2330
OUT time = 0300
Ingress & TCMS V3 will calculate the working time of the user as shown below:
1st working time = 1st OUT - 1st IN
= 1230 –0900
= 3 hours 30 minutes
2nd working time = 2nd OUT - 2nd IN
= 1745 – 1330
= 4 hours 15 minutes
3rd working time = 3rd OUT - 3rd IN
= 0300 – 2330
= 3 hours 30 minutes
Total working hours (without Calculate OT)
= 1st working time + 2nd working time + 3rd working time
= 3 hours 30 minutes + 4 hours 15 minutes + 3 hours 30 minutes
= 3 hours 30 minutes + 4 hours 15 minutes + 3 hours 30 minutes
= 11 hours 15 minutes.
Hence, Overtime
= 11 hours 15 minutes - 8 hours (working time set in clocking schedule)
= 3 hours 15 minutes
Attendance sheet will show work and overtime as below :
Hi,
ReplyDeletemay i know why my system not capture for break hour.
Can a worker clock in early and the system considers this as OT? some workers work early in the morning and we give that time as overtime
ReplyDeleteHello Daryl Keizerweerd,
DeleteYes, you can set for early login as Overtime in the schedule settings.
For example:
IN - 8AM
OUT - 5PM
In schedule setting, has enable for early login as OT , refer screenshot : http://prntscr.com/jlqwoc
So if user come early at 7:30AM , system will calculate overtime 30 minutes.
how we can calculating random time in /out any time mybe 10 time in/ 10 time out
ReplyDeleteSo As I understand it. The time range isn't a problem when the user has a flexi schedule.
ReplyDeletemeaning that the worker can also work at midninght and the hours will be calculated for that day he started.
Hello Daryl Keizerweerd,
DeleteFor your info, when you configure the Flexi Schedule, you can just let the Clocking Time blank. In the same time, you can refer to this article on how to configure the Check Out time as same working day when you work on midnight.
http://www.fingertectips.com/2018/02/how-to-better-use-features-available-in.html
Regards.
How can we setup to calculate overtime based on time and half and double time.. for example first 4 hours in a separate column and remaining overtime in another column
ReplyDeleteDear Sir / Ma'am,
DeleteGood day to you,
Referring to your inquiry, you may use the overtime differential rate interval in order for the system to display two separate columns (refer here http://prntscr.com/ozecy1). Generate your attendance sheet after changes are made in the clocking schedule.
You'll see there is a new column “Diff OT” appears on the Attendance Sheet. The software splits the OT hours with normal rate and different OT into 2 columns, which make it easy for viewing and reading (refer here http://prntscr.com/ozedg2)
Please send email to support@fingertec.com should you require further clarification on above issue as our team can assist you further.
Thanks & Best Regards.
Thank you Syafa,
ReplyDeleteBut what is the rate? What variables need to go in the fields?
Dear Sir,
DeleteGood day to you,
You need to fill up the value in the OT tab ( refer example: http://prntscr.com/ozx360 ). The value depends on your working hour requirement. For example, in the screenshot the first OT will be calculated after you had fulfilled 7h 36 minutes, then next it will be assigned to different OT (second OT) after you fulfill 9h 36 minute of working ( refer http://prntscr.com/ozx409 )
Awesome Help Syafa, I got it working..
ReplyDeleteHope you can help me with this one - I need to get employees to clock out and in for breaks or if they want to go out to attend personal matters and have to clock out and clock back in. I cannot see any Break out or In on terminal. How would you practically achieve this.
Thank you
Dear Sir,
DeleteGood day to you,
If you want to track the employees' attendance record for specific task, you may refer the link provided below
http://www.fingertectips.com/2015/11/ingress-tcms-v3-software-reports-for.html
Hi Syafa,
ReplyDeleteIs it possible to automatically adjust total working hour from overtime? For example, if an employee is 15 minutes late to work, but works 1 hour extra. Can the configuration be able to adjust the total working hour and gives 45minutes overtime?
Dear Sir / Ma'am,
DeleteGood day to you,
Referring to your inquiry, kindly be informed that the basic concept of flexi schedule is that it is used for those who have flexible working hour. Therefore, this type of schedule does not support the deduction of late in time from overtime. You can only find this option in weekly schedule (refer here http://prntscr.com/p27wby).
Thanks & best regards.
Thank you for the advice.
ReplyDeleteEarlier you had advised me to use to use differential rate. How can I use entire Holiday as Differential OT hours?
Thank you
Hello Sir,
DeleteRegarding to your query, you can change the Different OT rate for Holiday under System Setting > System Parameter Setting > Attendance tab (refer picture http://prntscr.com/p2ejrk). Regards.
Thank you Azmi,
ReplyDelete..
But I wanted all my holiday hours including Working hours to fall under Diff OT column.. How to change config to make that.
Thank you.
Hello Syafa/Azmi,
ReplyDeleteLet me explain further.
1. I have a situation where I need to setup the system to calculate hours on Saturday :
First 4 hours worked on Saturday to be overtime(time and half)
Any more hours after that to be Double Time
2. Holiday hours to be Double time.
3.Off Day to be Double time.
I presume that Diff OT column to be double time and Overtime column to be Time and Half.
How can I achieve this.
Thank you.
Dear Sir,
DeleteGood day to you,
First of all, you need to understand that the rule for Restday, Offday or Holiday , the employees need to fulfill the standard overtime then next total OT will be allocated under the differential overtime. You can not just allocated all the total OT directly under differential OT for Restday, Offday or Holiday
Refer below for example:
Clocking setting for Restday, Offday or Holiday : http://prntscr.com/p4i09m
Attendance sheet : http://prntscr.com/p4i0u0
Thank you Husna.
ReplyDeleteGreat help
It's superior, however , check out material at the street address. 900 seconds into minutes
ReplyDeleteHow to fix if I dont get overtime in hours and minutes, like if I get overtime 3.77 hours. I am having trouble with this, can you please explain so after 60 minutes the hours should be increased and the number after decimal point should correspond to minutes.
ReplyDelete