I have attendance sheet comprise on the following example:
Employee Name 1 to 31 column Formula Cell
Monday Tuesday Wednesday
Khan 10:00 10:05 10:10 ........ =
Khan-1 10:00 10:05 10:10 ........ =
As per company policy if any employee arrive after 10:00 then he or she must bear fine amount on month end.
Example:
if an employee came at 10:05 then the amount will be deducted 10.
if an employee came at 10:10 then the amount will be deducted 20.
if an employee came at 10:15 then the amount will be deducted 30.
so on
We need whole month deduction in one cell.
can anyone help me in this regard. If any confusion, do let me know.
Thanks in advance.
Employee Name 1 to 31 column Formula Cell
Monday Tuesday Wednesday
Khan 10:00 10:05 10:10 ........ =
Khan-1 10:00 10:05 10:10 ........ =
As per company policy if any employee arrive after 10:00 then he or she must bear fine amount on month end.
Example:
if an employee came at 10:05 then the amount will be deducted 10.
if an employee came at 10:10 then the amount will be deducted 20.
if an employee came at 10:15 then the amount will be deducted 30.
so on
We need whole month deduction in one cell.
can anyone help me in this regard. If any confusion, do let me know.
Thanks in advance.