Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
Re: Calculating Time & A Half On A Time Card
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
Re: Calculating Time & A Half On A Time Card
 |
Re: Calculating Time & A Half On A Time Card |
|
|
Thread Tools | Rate Thread |
25-06-2003, 01:16 PM
|
#1 |
|
Guest
Posts: n/a
|
Re: Calculating Time & A Half On A Time Card
See:
http://www.cpearson.com/excel/overtime.htm -- Regards, Peo Sjoblom "Karl" <JUSTFORFUN69K789@AOL.COM> wrote in message news:0a1101c33afb$945b2770$a301280a@phx.gbl... > 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 > |
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
