Re: how do I write a formula that will figure weekly overtime?

From: "CLR" <croberts@xxxxxxxxxxxxxxx>
Date: Sun, 3 Apr 2005 22:22:21 -0400

Total hours in A1
Rate per Hour in B1
In C1 put this formula......copy down if desired..........

=IF(A1<=40,A1*B1,(40*B1)+((A1-40)*B1*1.5))

Vaya con Dios,
Chuck, CABGx3

"jasperPcuccumber" <jasperPcuccumber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:01E9A355-B642-4CB4-803C-D543BE8EA624@xxxxxxxxxxxxxxxx
> I am setting up a payroll work***. I need a cell to show total hours,
one
> for regular time and one for over time. What formatting or formula can I
use
> to figure over time and straight time based on 40 overtime rule? (anything
> over 40 hours in a week is overtime)

.

Follow-Ups:
- Re: how do I write a formula that will figure weekly overtime?
  - From: jasperPcuccumber

References:
- how do I write a formula that will figure weekly overtime?
  - From: jasperPcuccumber

Prev by Date: Re: Effective Annual Interest Rate
Next by Date: if a cell contains certain text, cut and paste to another ***
Previous by thread: Re: how do I write a formula that will figure weekly overtime?
Next by thread: Re: how do I write a formula that will figure weekly overtime?
Index(es):
- Date
- Thread