Excel 2007 : Salary scheme

**Skjo** · 05-21-2011, 10:42 PM

Hi.
Im making a excel doc where i can make track of my working hours, and that my sallary is correct.

I want to fill in when i startet at work, and when i ended, and need a function that find how many hours i worked that day. Problem is that when i fill inn:
Start: End Break
0800 1600 0030
Its get messed up by the cell format and stuff, any tips?

Secound problem, i have a tax table, so when my scheme has found out how much i make BEFORE tax, i want it to auto find how much tax i need to pay.. the tax table is type:
If u make 10 000, u have to pay 1300 tax, if u make 11 000, u have to pay 1500 and so on....

Anyone?

**teylyn** · 05-22-2011, 01:02 AM

Hello,

if you want to make this easier, enter real "time" values, like 8:00 and 16:00. You can format these to appear with a leading zero (08:00) if you want. You can then use a simple formula like

=B1-A1-C1

(A1 = start time, B1 = end time, C1 = break )

For the tax lookup you need to create a table with two columns. The left column has the values 0, 10000, 11000 etc. The right column has the tax amount to pay for the income starting with the number in the left column. You can then use a formula like

=VLOOKUP(A6,H1:I5,2,TRUE)

A6 is the income earned, H1:I5 is the tax table.

See attached.

cheers,

Excel 2007 : Salary scheme

LinkBack

Thread Tools

Rate This Thread

Display

Salary scheme

Re: Salary scheme

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions