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:
- URL: https://linktechnologies.com.au/DEMO-LinkSOFT-LBS/Account/Login.aspx?ReturnUrl=%2fDEMO-LinkSOFT-LBS%2f
- Login: can use the default admin login
- Integration à Device Setup: enabled TI001
- TNA Rules: A001, A002, R003 & R011
- Processes: ESS021 & SYS001
- Employee Mapping à Henry Miller [E116] à Biometric ID: 1258
- Employee Shift: MDS1
- Imported File: TNA Time.csv
- 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:
- Employee Start is 4.58 am, as it is outside the start buffer of 15 mins
- From 4.58 am to 10.25 am = 5.45 hours, which = 327 minutes
- From 3.34 pm to 5.31 pm = 1.95 hours which = 117 minutes
- Add 2 and 3 = 7.4 Hours which = 444 minutes
- 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 2022 | 09:32AM Comment 1 by Sanjay (Link Technologies) Case L12713 added to project 13.50 |
07 Apr 2022 | 09:34AM Comment 2 by Sanjay (Link Technologies) ETC was changed from 07/04/2022 to 30/04/2022 |
07 Apr 2022 | 09: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 2022 | 01: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. - TNA Setup Rule R003 is enabled in this example, therefore the computation is not according to your expectations.
- 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"
- 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 2022 | 12:21PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 30/04/2022 to 30/04/2022 |
17 May 2022 | 09: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 2022 | 09:12AM Comment 7 by Sanjay (Link Technologies) Case L12713 removed from project 13.50 |