Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need a lot of help with MS Excel 2010
I am trying to do a tracking sheet that will automatically calculate the totals for me. I get pd. Bi-Weekly @ 18.29 per hr. I also get a shift differential of .72 per hour for shifts between 4 pm and 7 am. I get a weekend differential as well of 1.25 per hour for weekend shifts between Saturday 12 am to Monday 12 am. Overtime is calculated at 1.5 and holiday shifts are double time.
During evening shifts and overnight shifts i get paid breaks (2 @ 15 minutes) and supper (1/2 hour). I downloaded a template and tried playing around with it but i just can't make sense of the formula's. Here is a link of what i have done so far. file:///C:/Users/Marg/Documents/MY%20NEW%20PAYROLL%20TRACKER%20FOR%20EXCEL%202010. htm I hope someone can help me , i have no clue what to do now that i have put in some of my own information on the template. My payroll from work has been wrong this past 2 pay periods and that is why i decided maybe i can keep track also. Thanks in advance for any help and i hope the link above works. Marg Jackman Last edited by Lambshots : March 12th 13 at 03:58 PM Reason: Not sure about the link working |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a lot of help with MS Excel 2010
On Fri, 8 Mar 2013 01:49:35 +0000, Lambshots
wrote: During evening shifts and overnight shifts i get paid breaks (2 @ 15 minutes) and supper (1/2 hour). In the US, ALL hourly workers get a 15 minute break after each two hour work session. They are always ON THE CLOCK. The lunch period is NOT on the clock. This is from the US Labor Relations Board. Most states pay for any OT that is beyond 8 hours in a single day, and that at 1.5 times the base rate. Some convolute it to pay only those hours that are greater than 40 in a week. So, in a 'normal', 'complete' "40 hour week", that would make any weekend work as OT automatically. The double rate polices are usually per company or per contract or per organization. You should post the link for the original template you used. The 'link" you posted to your "file" will not work, as you would need to upload the file to some web based file hosting place first and then post that link. |
#3
|
|||
|
|||
Here is the original Time Sheet i was using. I saved it as a ZIP File so i could upload it here. The shifts i work with Eastern Health, Government Employee is a 35 hr week and during the day shift there are 2 paid breaks in the 7.5 hour day and 1/2 hr unpaid dinner.
During an evening shift the 2 - 15 minute breaks are paid as well as the supper break (1/2 hr) because there is no one to relieve you as you are working this shift alone. The overnight shift is all paid breaks 15 + 15 +1/2 hr. Thank you for your help [quote=CellShocked;1610163]On Fri, 8 Mar 2013 01:49:35 +0000, Lambshots wrote: During evening shifts and overnight shifts i get paid breaks (2 @ 15 minutes) and supper (1/2 hour). QUOTE] Last edited by Lambshots : March 12th 13 at 01:52 AM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2010 to auto-generate an email to recipients in outlook 2010 | Excel Programming | |||
Alt-F8 and Excel 2010 | Excel Programming | |||
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming |