I need to create a formula where it adds regular 40-hour pay plus overtime in
the same cell/formula.

also, I need to create Conditional Formatting to highlight students who got
80+ on 5 consecutive tests.

BH

First for the OT

http://www.cpearson.com/excel/overtime.htm

Second for the CF

http://www.contextures.on.ca/xlCondFormat01.html


Gord Dibben MS Excel MVP

On Thu, 15 Nov 2007 19:29:01 -0800, Payroll <Payroll @discussions.microsoft.com
wrote:

I need to create a formula where it adds regular 40-hour pay plus overtime in
the same cell/formula.

also, I need to create Conditional Formatting to highlight students who got
80+ on 5 consecutive tests.

BH

Part 1 - =IF(A1040,(A10*15)+((A10-40)*7.5),A10*15)

Part 2 - =MIN(B1:F1)80

"Payroll" wrote:

I need to create a formula where it adds regular 40-hour pay plus overtime in
the same cell/formula.

also, I need to create Conditional Formatting to highlight students who got
80+ on 5 consecutive tests.

BH