Please help to find out net variance between NetHrs Clocked and Net Hrs due of the employee

  • Thread starter Thread starter polachan
  • Start date Start date
P

polachan

Guest
I am looking for the help to create the function in C# to find the Variance Hrs between His DueHrs and ClockedHrs

If an Employee come in 15 minitus early or leave 15 mins late then only 10 mins be considered as his extra time worked. So his extra time would be considered only after 10 mins from clock in and clock out


But if he clocked in 5 mins late and he left 12 mins late then his variance would be 0. Because after compensating his late coming , he has only balance 7 mins. that means after compensating the late hrs, he has excess 10 mins, then the variance would be the differece after 10 mins.

if an employee is not entitled to work but if he has come for work , then the variance would be the difference between the clockout and clockin. [10 mins rule will not be applied]

Please find my workout in excel given below. Every calculation is done in mins . Please can you help me how to write a function in c# to get the variance

1514145.png

With Thanks

Pol


polachan

Continue reading...
 
Back
Top