Thank you,
This is very useful for hourly employees, unfortunatelly I am salaried.
fyi, I have the answer now.
Thanks again.

"NancyJeanne" wrote:

I handle payroll for 50 employees. I set up a spreadsheet that handles this
for me giving me a way to double check the info entered into the payroll
system before I process.

In Row 1 Set up the following columns: Column A-Name; Column B-Reg Hours;
Column C-OT Hrs; Column D- Rate of Pay; Column E- Reg Total; Column F-OT
Total; Column G-Gross
If you want you can change the Name column to date so that it becomes a
database of hours worked on a per pay period basis.
You will manually enter the weekly info into columns A-C.
Starting the first week in row 2 do the following:
In Column D enter your current rate of pay.
Column E formula =B2*D2
Column F formula =sum(C2*D2)*1.5 for time and a half or ...)*2 for double
time
Column G formula =E2+F2
To have a database on a week by week basis you can copy columns D-G down
several rows and just enter columns A-C weekly.
Hope this helps


"help in CA" wrote:

I am on salary (weekly) but always work alot more than 40 hrs per week.
How can I make a spreadsheet that will calculate my rate of pay on a weekly
basis, by me typing in the hours worked per week(ex; 40 reg + 20 overtime)

Please Help,

Thanks in advance.