Working Hours Calculation with Overnight-Flexi Schedule in Ingress & TCMS V3

Friday, June 16, 2017 FingerTec 20 Comments


overnight2.jpg

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
= 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 :



20 comments:

  1. Hi,

    may i know why my system not capture for break hour.

    ReplyDelete
  2. 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

    ReplyDelete
    Replies
    1. Hello Daryl Keizerweerd,

      Yes, 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.

      Delete
  3. how we can calculating random time in /out any time mybe 10 time in/ 10 time out

    ReplyDelete
  4. So As I understand it. The time range isn't a problem when the user has a flexi schedule.
    meaning that the worker can also work at midninght and the hours will be calculated for that day he started.

    ReplyDelete
    Replies
    1. Hello Daryl Keizerweerd,

      For 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.

      Delete
  5. 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

    ReplyDelete
    Replies
    1. Dear Sir / Ma'am,

      Good 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.

      Delete
  6. Thank you Syafa,

    But what is the rate? What variables need to go in the fields?

    ReplyDelete
    Replies
    1. Dear Sir,

      Good 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 )

      Delete
  7. Awesome Help Syafa, I got it working..

    Hope 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

    ReplyDelete
    Replies
    1. Dear Sir,

      Good 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

      Delete
  8. Hi Syafa,

    Is 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?

    ReplyDelete
    Replies
    1. Dear Sir / Ma'am,

      Good 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.

      Delete
  9. Thank you for the advice.

    Earlier you had advised me to use to use differential rate. How can I use entire Holiday as Differential OT hours?
    Thank you

    ReplyDelete
    Replies
    1. Hello Sir,

      Regarding 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.

      Delete
  10. Thank you Azmi,
    ..
    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.

    ReplyDelete
  11. Hello Syafa/Azmi,

    Let 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.

    ReplyDelete
    Replies
    1. Dear Sir,

      Good 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

      Delete

Have any questions or inquiries about FingerTec? Drop your input here.