Excel spreadsheet?

I have this simple sheet to calculate my duty hours and also my courses hours and calculate the paying.

I can send it over and teach you how to use it, or I can teach you how to make one on your own.

But I need your e-mail, send it over, and mark my answer as best.

Read my profile, I am the XLMan

I agree that Access may be better for something like this, though the learning curve is much higher.

To create a basic payroll system, you may want to create the following columns:

Employee Name - S|M|T|W|T|F|S (hours worked per day) - Hourly Wage - Total per week (hours * Rate) - Tax rate - Total (weekly total - taxes).

That is pretty simple, but should do the trick for a small business

There are some templates you can download for free on the Microsoft Office website for timecards/payrolls that already have the formulas input. This is what I would recommend, as it can save lots of time.

Microsoft Office Templates

http://office.microsoft.com/en-us/templates/defaul...

Excel Template - Weekly Time Sheet

http://office.microsoft.com/en-us/templates/TC0608...

Excel Template - Payroll Calculator Spreadsheet

http://office.microsoft.com/en-us/templates/TC0610...

Otherwise, you can try putting the formulas in manually, but this will take more of your time.

It would be better to create an MS Access database. You can have a simple data entry form to enter your information, plus the query and reporting functions are good.