Premium Pay

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

I think this is what you're looking for:

Beginning in Cell A1 headers are Date, Hours, Basic Pay, OT Pay, Premium
Pay.

In C2, enter:

=IF(B2>8,8,B2)

In D2, enter:

=IF(B2>8,B2-C2,0)

In E2, enter:

=IF(WEEKDAY(A2)=1,B2,0)

and copy these down as needed.

The formulae in column C and D assume 8 hours is a standard workday, so
change as appropriate.

HTH
Mike

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain
 
I am currently making a spreadsheet to work out my monthly pay. I am
wondering if Excel is clever enough to recognise what day a date falls on?

I am entering my hours worked on specific dates, however I receive time and
a half when I work on a sunday. I have seperate columns for basic pay,
overtime pay and premium pay (time and a half). Is there anyway I can make
the cells in the premium pay column look at the hours worked in the basic
pay and overtime pay column, and then look at the date and see if it is a
Sunday. If so, I want the cell in the premium pay to be filled in!

Thanks in advance
 
I now have a column which automatically fills out the day for me. Now what I
would like to do is, if the day in the cell in that column is Sunday, I
would like the amount of hours in the "basic hours" worked cell to copy into
the "premium" column cell.
 
Hi
can you give some cell references for this (where is your hour amount,
there is your premium amount). In general you may use something like
=IF(WEEKDAY(A2,1)=1,hour_amount_cell_reference,"")
 
Back
Top