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

With Thanks
Pol
polachan
Continue reading...
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

With Thanks
Pol
polachan
Continue reading...