New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

calculate and deduct late arrivals

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

calculate and deduct late arrivals

Postby amrita » Mon Jun 13, 2016 12:50 am

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
  • 0

amrita
Rookie
 
Posts: 2
Joined: Jun 13, 2016
Reputation: 0
Excel Version: 2013

Re: calculate and deduct late arrivals

Postby ConneXionLost » Mon Jun 13, 2016 2:07 pm

How about:

Code: Select all
=(A1>=4)+MAX(0,A1-4)/2


Where A1 is the number of late days.

Cheers,
  • 0

ConneXionLost
Regular
 
Posts: 68
Joined: May 9, 2013
Location: Canada
Reputation: 19
Excel Version: 2003, 2010

Re: calculate and deduct late arrivals

Postby amrita » Tue Jul 05, 2016 12:09 am

Thank you so much, it worked...:))
  • 0

amrita
Rookie
 
Posts: 2
Joined: Jun 13, 2016
Reputation: 0
Excel Version: 2013


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 59 guests