late comers salary deduction through attendance

[msk1972]

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.

 

[iliace]

Is it based on 5-minute intervals, or is it proportionate to the minute? If for each 1 minute there is a deduction of 2, then you can do something like this:

Excel Workbook
	A	B	C	D	E	F	G
1		Monday	Tuesday	Wednesday	Thursday	Friday	Penalty
2	Row 1	9:56	10:10	10:01	10:19	9:58	60
3	Row 2	9:50	10:09	10:08	9:57	10:13	60
4	Row 3	10:15	9:51	10:05	10:00	10:09	58
5	Row 4	10:15	9:50	10:10	10:03	10:02	60
6	Row 5	10:12	9:59	10:08	9:57	10:04	48
7	Row 6	9:57	10:03	10:07	10:10	10:12	64
8	Row 7	10:11	10:09	9:50	9:54	10:07	54
9	Row 8	10:03	10:16	10:13	10:13	10:17	124
10	Row 9	10:15	10:01	9:59	10:10	9:53	52
sheet

 

[msk1972]

Dear Mr. iliace

I am really thankful to you for your prompt reply. The solution you have provided is absolutely perfect and applied successfully.

Thanks again, keep in touch, do take very good care of yourself.

bye for now.