late comers salary deduction through attendance

msk1972

New Member
Joined
May 3, 2005
Messages
7
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.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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
ABCDEFG
1MondayTuesdayWednesdayThursdayFridayPenalty
2Row 19:5610:1010:0110:199:5860
3Row 29:5010:0910:089:5710:1360
4Row 310:159:5110:0510:0010:0958
5Row 410:159:5010:1010:0310:0260
6Row 510:129:5910:089:5710:0448
7Row 69:5710:0310:0710:1010:1264
8Row 710:1110:099:509:5410:0754
9Row 810:0310:1610:1310:1310:17124
10Row 910:1510:019:5910:109:5352
sheet
 
Last edited:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,830
Messages
6,121,835
Members
449,051
Latest member
excelquestion515

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top