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

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.

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]