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