HR, Payroll, Attendance Software › Forums › Lenvica HRMS › Ask a Question › Penalty calculation For Absent Time and days

Viewing 3 reply threads
  • Author
    Posts
    • Anonymous
      Inactive
      November 9, 2014 at 20:36
      Post count: 2
      #19303

      Hello,

      Can anyone please give me the formula how I can deduct from Employee
      salary for each late in minutes, early out minutes and absent days?

      I tried this formula but its not working for me  >:(  >:(

      Penalty For Absent Time =  [<Late In_Hours>  +  <Early Out_Hours>  +
      <Absence_Days>]*[Rate Per Hour]

      Waiting for your reply

      Regards,

    • Rijo Pappachan
      Member
      December 3, 2014 at 10:47
      Post count: 92
      #20143

      Hi Abel,

      The value of variable <Absence_Days> is in 'Days' where in the other variables  <Late In_Hours> and <Early Out_Hours> are in 'Hours'. You need to convert <Absence_Days> to hours. That is <Absence_Days> * Planned work hours of a day.

      Ex:
      Penalty For Absent Time =  [<Late In_Hours>  +  <Early Out_Hours>  + (<Absence_Days> * 9)  ] * [Rate Per Hour]

      Hope this helps

      Contact support@lenvica.in for on-line support.

      Regards,
      Rijo

    • Anonymous
      Inactive
      December 4, 2014 at 13:08
      Post count: 2
      #20144

      Hello,

      Thank you your reply.

      I tried the formula with only late in time and early out time and it is not working for me :(

      For Example.

      When I check this report for Four days

      Attendance -> Attendance Report -> “Report on Planned And Actual Work Time Duration for a selected Period”
      I get  ————– “- 00:24” ————– this is a wasted time for the selected employee and we need to deduct from his salary for this amount multiplied by his hourly rate.

      So I created a Salary head called “Absent Day and Time Penalty” and set the formula as:
      (<Early Out_Hours> + <Late In_Hours>)*[Rate Per Hour]
      Where [Rate Per Hour] is 20

      When I process salary for the given date (four days) I should get (0.24(Total wasted time)*20(Rate per hour)) 4.80 as a Penalty but I am getting 0 (zero). I think I have missed something …

      Can you please help me?

      See the attachment for details

      Attachments:

    • Rijo Pappachan
      Member
      January 13, 2015 at 06:49
      Post count: 92
      #20145

      Hi Abel,

      We need to check on-line to get more info on the  scenario.

      Please send your company name and contact details to contact@lenvica.in

      We will arrange on-line assistance.

      Regards,
      Rijo

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.