Employee Time Card Extras

[FemaleFatale]

Hello,

I am new here. I just figured out how to create a weekly timecard
spreadsheet that could tally basic in/out hours which includes time off
for lunch. However, I would like to take it one step further and have
the sheet also *calculate hours worked for a bi-weekly pay period as
well as doing things like deducting tax and medical as well as tallying
OT, SICK, and VACATION* .

Is it possible to have a Timecard determine all of these things? Please
let me know. Also, I am a complete NEWBIE using Excel so please
provide as much details as possible when replying.

Thanks in advance.

 

[Frank Kabel]

Hi
yes in general this is possible
To give you some starting points have a look at the following sites for
some example timesheets
http://j-walk.com/ss/excel/files/timesht.htm
http://www.cpearson.com/excel/overtime.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm

 

[FemaleFatale]

Thanks Frank - I will check out these links later.
In the meantime could anybody else help with the questions I had wit
wanting to determining the tax decuction for that pay period or an
other deductions that need to be taken out?

Thanks in advance!

 

[David McRitchie]

I did not see anything about calculating tax in this thread.

Totaling a tax deduction in a column is one thing, but to simply show how to
calculate the tax deduction is not. When I worked on payroll programs
there was a company that created tables for Federal Income tax and
taxes for each state that would be compiled into a subroutine for use
in programs. The tables themselves along with a certification letter
for each filled up a notebook. The program probably was 3000 to
4000 cards.

Though I don't expect you would find doing tax deductions in John
Walkenbach's timesheet example, I would say that since you haven't
looked at what was suggested yet you may be jumping the gun.

In anycase your question needs a lot more thought as to what you
are asking and can reasonably expect as help.

 

[Peo Sjoblom]

http://www.mcgimpsey.com/excel/taxvariablerate.html

 

[FemaleFatale]

Thanks for helping guys, I'll let you know if any of the informatio
helped with what I am attempting to do