Company: Link Technologies
Case No: L12713
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 06 Apr 2022 02:01PM
Priority: High
Product: Payroll & HR
Group: Enhancement
Time Taken: 17.00 (Weight: 24.00)
Version: 13.50
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Sanjay
Resolve By: Saturday, 30 April 2022 11:59 PM [960 days since logged date]
Status: Closed
Subject: TNA Hours calculations is not clear on the Timesheets view
Summary:    

 Hi Sanjay

We have a setup where the system calculated hours that do not match our manual calculations. We requested assistance for verification. Refer below setup:

 

  1. URL: https://linktechnologies.com.au/DEMO-LinkSOFT-LBS/Account/Login.aspx?ReturnUrl=%2fDEMO-LinkSOFT-LBS%2f
  2. Login: can use the default admin login
  3. Integration à Device Setup: enabled TI001
  4. TNA Rules: A001, A002, R003 & R011
  5. Processes: ESS021 & SYS001
  6. Employee Mapping à Henry Miller [E116] à Biometric ID: 1258
  7. Employee Shift: MDS1
  8. Imported File: TNA Time.csv
  9. Verified the Timesheet Login Screen – the system calculated 4.98 hours. Refer to Figure 1: Timesheet Screen

 

Figure 1: Timesheet Screen


 Accordingly, to my calculation the hours should be 6.4, which is made up of the following:

  1. Employee Start is 4.58 am, as it is outside the start buffer of 15 mins
  2. From 4.58 am to 10.25 am = 5.45 hours, which = 327 minutes
  3. From 3.34 pm to 5.31 pm = 1.95 hours which = 117 minutes
  4. Add 2 and 3 = 7.4 Hours which = 444 minutes
  5. From 4 above, we will deduct lunch of 1 hours = 7.4 – 1 = 6.4 hours which = 384 minutes


** Kindly help us to understand how the system calculated 4.98 hours?

Audit Notes:Edited by sanjay on 17/05/22 09:12. Edited by sanjay on 13/05/22 11:46. Edited by sanjay on 12/05/22 09:17. Edited by sanjay on 11/05/22 12:21. Edited by sanjay on 07/04/22 09:34. Edited by aarti on 06/04/22 14:01. 
07 Apr 202209:32AM Comment 1 by Sanjay (Link Technologies) Case L12713 added to project 13.50
07 Apr 202209:34AM Comment 2 by Sanjay (Link Technologies) ETC was changed from 07/04/2022 to 30/04/2022
07 Apr 202209:35AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-04-2022 01:34 PM Time Taken: 3.00
We need a better way to see how the timesheet data was calculated so that the user can see how data was used in preparing the Time record

07 Apr 202201:39PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-04-2022 01:35 PM Time Taken: 12.00 Notes: Edited by sanjay on 17/05/22 09:11. 

Hi Aarti, To get the results you want, you should turn OFF TNA Setup Rule R003.

  1. TNA Setup Rule R003 is enabled in this example, therefore the computation is not according to your expectations.
  2. R003 transforms "MULTIPLE IN" to BREAK IN. Therefore, the third entry in your IMPORT DATA (Which is a SECOND IN) is transformed into a "BREAK-IN"
  3. R003 also uses the SHIFT to determine the Normal hours.

In your example, the time will compute to 7.4 Hours as there are two IN and OUT entries as shown in figure 1 below. Note that 1-hour LUNCH is not reduced as the employee didn't work during the lunch break.

Figure 1 - TNA with Rule R003 turned off


11 May 202212:21PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 30/04/2022 to 30/04/2022
17 May 202209:12AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-05-2022 01:10 PM Time Taken: 2.00
An explanation for the calculation has been provided. Since no change is required to the system, this case will be removed from Project 13.50

17 May 202209:12AM Comment 7 by Sanjay (Link Technologies) Case L12713 removed from project 13.50
Attachments:
General Documents - Case: L12713:20220406105301183_TNA Time.csv
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12713 in the subject line of all emails regarding this issue.

Document size: 192.7 KB
For call complaints, please contact the Managing Director of the company using this form