#### Related Topics:

Posted on Sep 28, 2007

### Anonymous

Level 1:

An expert who has achieved level 1.

• Posted on Nov 16, 2007
Contributor
Level 1:

An expert who has achieved level 1.

Joined: Nov 15, 2007
2
Questions
1
Helped
316
Points
2

Go to the Microsoft Template Gallery:

http://office.microsoft.com/en-us/templates/default.aspx

they have several different types there - payroll calculators, payroll and headcount planning, etc.

×

my-video-file.mp4

×

## Related Questions:

Inventory
Purchase

### I am trying to figure out a payroll formula. I

Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B
8
8
8
2
8
8
0
Total 40 OverTime 2

Formula in this cell where 40 is at:
=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:
=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

### Need help with excel formula

The solution would be to have an input column(e.g. A) that is separate to the hours and overtime columns. Then in the hours column enter =IF(A1<40,A1,40) and in the overtime column =IF(A1<41,0,A1-40)
Oct 28, 2009 • Microsoft Excel for PC

### Payroll set up with child support garnishment etc. in Quickbooks

You have to link the payroll item to payroll liabilities account. The default setup links them to a general account of payroll expenses and or payroll liabilities. You have to setup individual accounts in the chart of accounts and link the related payroll item to the account.
www.cpahispano.com

### How to create and solve the payroll in tally

How to Create in Payroll in Tally 9? Please Explain neatly
Mar 14, 2009 • Tally T2250 Matrix Printer

### Code for find the Ms access database size using visual basic

The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.

To import the text files using VB 8 use

'Imports System.Data.OleDb Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb") Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn) conn.Open() cmd.ExecuteNonQuery() conn.Close()

227 views

Level 3 Expert

Level 3 Expert