Re: Calculating Time & A Half On A Time Card

See:

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

--

Regards,

Peo Sjoblom


"Karl" <(E-Mail Removed)> wrote in message
news:0a1101c33afb$945b2770$(E-Mail Removed)...
> Calculating Time & A Half On A Time Card
>
> Could any one tell me what formula to use to calculate
> time & a half on my time card?
> The tricky part is that; this is for a time card that is
> on a 2-week schedule. Where anything over 40 hours in week
> 1 is paid as time & a half, and anything over 40 hours in
> week 2 is paid as time & a half.
> I like to figure my gross pay day by day so I need a
> formula that reflects the following.
>
> (Keep in mind Friday has 2 hours that need to be
> calculated at time & a half. Although this time & a half
> could occur any day of the week)
>
> Week 1:
> Monday: 8 (hours) x $10.00 (pay) = $80.00 (gross pay
> for the week)
> Plus
> Tuesday: 8 (hours) x $10.00 (pay) = $160.00 (gross
> pay for the week)
> Plus
> Wednesday: 8 (hours) x $10.00 (pay) = $240.00 (gross pay
> for the week)
> Plus
> Thursday: 8 (hours) x $10.00 (pay) = $320.00 (gross pay
> for the week)
> Plus
> Friday: 10 (hours) x $10.00 (pay) = $430.00 (gross
> pay for the week)
>
> Week 2:
> Monday: 8 (hours) x $10.00 (pay) = $80.00 (gross pay
> for the week)
> Plus
> Tuesday: 8 (hours) x $10.00 (pay) = $160.00 (gross
> pay for the week)
> Plus
> Wednesday: 8 (hours) x $10.00 (pay) = $240.00 (gross pay
> for the week)
> Plus
> Thursday: 8 (hours) x $10.00 (pay) = $320.00 (gross pay
> for the week)
> Plus
> Friday: 10 (hours) x $10.00 (pay) = $430.00 (gross
> pay for the week)
>
> 2 Week Total Gross Pay = 88 (hours) x $10.00 (pay) =
> $860.00
>
> Thanks For Your Help
>