Employee Time Card Extras

  • Thread starter Thread starter FemaleFatale
  • Start date Start date
F

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.
 
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!
 
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.
 
Thanks for helping guys, I'll let you know if any of the informatio
helped with what I am attempting to do
 
Back
Top