Hello, my boss is having me do just about everything at my new job and it is killing me. I have recently been tasked with payroll as well which has been done with pen and paper because of the convoluted payment method: There is more than one location and each has it's own antiquated time punch software and employees frequently work at more than one location. If somebody can help me sort out the formulas needed for this I would be extremely grateful!
1) Weekend rate for certain employees is *1.25 (needs to be in [hh]:mm)
2) Overtime rate is *1.5 (needs to be in [hh]:mm)
4) Overtime is not paid out in same pay period but is carried forward as a credit called comp time, where if said employee works less than 80 hours next pay period, then the comp time is added until the employee meets the 80 hour threshold.
4) Holiday rate is *1.5 (needs to be in [hh]:mm). This also becomes comp time if it puts an employee over 80 hours in a pay period.
5) Total Hours need to be presented in [hh]:mm
Note: I do not calculate the hours (times) pay rate, like many others have asked, but just the total hours and minutes and my boss then puts those numbers into the payroll software which calculates how much to pay each employee.
I have started an Excel spreadsheet with the required fields and have attempted some formulas with degrees of success. Here are the headers, sorry I couldn't fit them all on one line. Please feel free to add any columns necessary.
<table border="0" cellpadding="0" cellspacing="0" width="1044"><col width="181"><col span="9" width="85"><col width="98"><tr height="20"> <td class="xl63" style="height:15.0pt;width:136pt" height="20" width="181">Name</td> <td class="xl67" style="width:64pt" width="85">Reg Hours
</td> <td class="xl66" style="width:64pt" width="85"> Wknd </td> <td class="xl66" style="width:64pt" width="85">(x1.25)</td> <td class="xl64" style="width:64pt" width="85">O/T</td> <td class="xl64" style="width:64pt" width="85">
</td> <td class="xl69" style="width:64pt" width="85">
</td> <td class="xl69" style="width:64pt" width="85">
</td> <td class="xl65" style="width:64pt" width="85">
</td> <td class="xl70" style="width:64pt" width="85">
</td> <td class="xl68" style="width:74pt" width="98">
</td> </tr></table>
<table border="0" cellpadding="0" cellspacing="0" width="1044"><tr height="20"><tr height="20"><td class="xl64" style="width:64pt" width="85">(*1.5)</td><td class="xl69" style="width:64pt" width="85">Holiday </td><td class="xl69" style="width:64pt" width="85">(*1.5)</td><td class="xl65" style="width:64pt" width="85">Comp Time</td><td class="xl70" style="width:64pt" width="85">Total</td><td class="xl68" style="width:74pt" width="98">Remaining C/T</td></tr></tr></table>
Again, any help would be greatly appreciated! Looks like I will have to do this weeks payroll by hand again in the meantime.
JDubACM
1) Weekend rate for certain employees is *1.25 (needs to be in [hh]:mm)
2) Overtime rate is *1.5 (needs to be in [hh]:mm)
4) Overtime is not paid out in same pay period but is carried forward as a credit called comp time, where if said employee works less than 80 hours next pay period, then the comp time is added until the employee meets the 80 hour threshold.
4) Holiday rate is *1.5 (needs to be in [hh]:mm). This also becomes comp time if it puts an employee over 80 hours in a pay period.
5) Total Hours need to be presented in [hh]:mm
Note: I do not calculate the hours (times) pay rate, like many others have asked, but just the total hours and minutes and my boss then puts those numbers into the payroll software which calculates how much to pay each employee.
I have started an Excel spreadsheet with the required fields and have attempted some formulas with degrees of success. Here are the headers, sorry I couldn't fit them all on one line. Please feel free to add any columns necessary.
<table border="0" cellpadding="0" cellspacing="0" width="1044"><col width="181"><col span="9" width="85"><col width="98"><tr height="20"> <td class="xl63" style="height:15.0pt;width:136pt" height="20" width="181">Name</td> <td class="xl67" style="width:64pt" width="85">Reg Hours
</td> <td class="xl66" style="width:64pt" width="85"> Wknd </td> <td class="xl66" style="width:64pt" width="85">(x1.25)</td> <td class="xl64" style="width:64pt" width="85">O/T</td> <td class="xl64" style="width:64pt" width="85">
</td> <td class="xl69" style="width:64pt" width="85">
</td> <td class="xl69" style="width:64pt" width="85">
</td> <td class="xl65" style="width:64pt" width="85">
</td> <td class="xl70" style="width:64pt" width="85">
</td> <td class="xl68" style="width:74pt" width="98">
</td> </tr></table>
<table border="0" cellpadding="0" cellspacing="0" width="1044"><tr height="20"><tr height="20"><td class="xl64" style="width:64pt" width="85">(*1.5)</td><td class="xl69" style="width:64pt" width="85">Holiday </td><td class="xl69" style="width:64pt" width="85">(*1.5)</td><td class="xl65" style="width:64pt" width="85">Comp Time</td><td class="xl70" style="width:64pt" width="85">Total</td><td class="xl68" style="width:74pt" width="98">Remaining C/T</td></tr></tr></table>
Again, any help would be greatly appreciated! Looks like I will have to do this weeks payroll by hand again in the meantime.
JDubACM
