Hi,
I have an excel sheet with employees name and total no of days they have been late in a month.
The deduction rules are 1 day for every 4 days late arrival and then half a day for subsequent late.
eg: if a person is late for 10 days then 4 days salary has to be deducted (1 day for first 4 days and .5 day for rest 6 days)
What formula can I use in my excel to automatically calculate this??
Thanks